Vlookup result return blank in read range activity?

[alvin.c.apostol26 (Alvin)]

Hi UiPath,

Just want to confirm if there is a way to read the vlookuop result using Read Range activity?

I have the following example below:

For some reason the result of the vlookup is returning blank when I read this file using Read Range activity and save it in a datatable

hope this makes sense

[Yoichi]

Hi,

Which Read Range activity do you use? How about using Modern ReadRange(ReadRangeX)?

It may be necessary to set Display value at ReadFormatting in UseExcelFile.

Regards,

[alvin.c.apostol26 (Alvin)]

Thank you it worked! @Yoichi