Vlookup result return blank in read range activity?

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

Hi,

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

image

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

Regards,

1 Like

Thank you it worked! @Yoichi

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.