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