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?


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


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.