Copy Value from Vlookup function

excel
activities

#1

Hello,

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?


#2

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


#3

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.