Well @sarathi125 thanks for the response and sorry for the delay to revert, your workflow is good but in the lookup activity you are using a datatable dtMtest and the lookup column and target column belong to same datatable, in my problem the values are coming from different datatables. 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 ‘BGrcy.xlsx (9.2 KB) PAC_abc.xlsx (9.2 KB) (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.
@Palaniyappan also please look on to this.
Please revert with a solution