Copy Value from Vlookup function


I am trying to copy an entire column that uses VLOOKUP function from an Excel document. I Used ReadRange activity to read the column in a data table. When I try to write what the datatable contains into another workbook, it shows only this number “-2146826265” on the entire column. Do you have any suggestions on how I can read in the datatable only the value?

1 Like

Once the values are populated in the column using VLOOKUP, try replacing the formulas with the values (VLOOKUP result) and read the column to a data table

1 Like

Usually, this number means that your got error result in VLookup.
Try to recalculate value in Excel (F9).

I read cells with Vlookup all times and pretty happy with results.

Andra , did you find any solution to it