Vlookup activity1

Help Activities
, ,
1

Hi all,

I have Excel1 with Column AZ and excel2 with Columns H and V.
I need to do look up of AZ column with reference to H and V column.

I cannot use For each row activity as I have huge data. Can anyone provide me a solution for this.

Any help is more appreciable.

2

Hi @0bb4628e217fd43ac86ac9294

Could you please share some sample input and output excel files.

Regards,

1 Like
3

|Bill_ID | Name | Bill_Currency |
|qrt | qwer | INR |
|qfgt | tyyu | INR |
|huy | uiyt | INR |
|jjo | ryui | INR |
This is my Excel 1 please consider Bill_Currency column

|Bill_Curr_code | Item | Latest_fadai | code|
|INR | 1 | 1 | 001|
|EUR | 2 | 90.16 | 002|
|INR | 3 | 1 | 003|
|EUR | 4 | 90.16 | 004|
|INR | 5 | 1 | 005|
This is my excel2 consider Bill_Curr_code and Latest_fadai as the columns

4

@0bb4628e217fd43ac86ac9294

Please share expected output also

Regards,