Vlookup in UiPath


#1

Hi All,
I’m trying to migrate some logic from an excel that we need to replace.
I do this in the excel:

=IF(
ISNUMBER(M2*1);
IF(
ISERROR(VLOOKUP(M2;Wagon!$A$2:$A$6601;1;FALSE));
“OTHER”;
VLOOKUP(M2;Wagon!$A$2:$T$6601;20;FALSE)
);
"-")

I have two sheets that I read into two data tables.

Table1:

M2, Owner (with formula above)
123, ME
134, OTHER

Wagon:

Key,Key2,Key3,,,,,,,,Owner
123,        ,        ,,,,,,,, ME
138,        ,        ,,,,,,,, ME
145, 167 ,109  ,,,,,,,,,ME

Any ideas how I can do this in UiPath if I import the data to two different data tables?

Br
Cristian


#2

Hi @cristian_ivanoff,

There is a new activity for Vlookup.

image

You can download it from the packages.


#3

Are there any details / documentation for the Properties in this new VLOOKUP activity? I am not seeing the same options / values as the Excell VLOOKUP.

Is ValueToLookup the same as Lookup_value? A cell?
Is Value the result of the lookup?
Is ? the same as Range_value??

Thanks.


#4

Dears,

if someone already used VLookUpforUipath? If some one has simple example, I will really appreciate! Can someone explain on the simple example as " in Excel we will use this formula. In VLookUpforUipath in the frame Column_index we will write this, in Value that, into ValueTo Lookup needs to put information like this"…

Thank you!!!