I am facing some issues while applying vlookup between two excel file sheets using the lookup datatable activity in uipath.
Can anyone please provide help for how to properly apply Vlookup or lookup datatable between two different sheets of different files.
Let me explain see for example there are two files say PAC_abc.xlsx and the other is Grcy.xlsx file, both are attached. For the solution i have to - " In Col ‘AF(column32) of file PAC_abc.xlsb’
Apply VlookUP from “Grcy.xlsx” file Tab “Grcry” col
‘A’(column1) using the key col ‘B(Column2)’ in PAC_abc.xlsx ".
this is the type of which i am trying to find solution, tab is sheet here.
If any issues or confusion please revert asap i will clear it.