Hi all, I have 2 excel sheets (example below), I want to loop for each row to find are there any rows that company name in sheet 1 match the company name in sheet 2. For the matching rows, I need to copy the whole row and paste to sheet 3.
Is vlookup activity the easiest way to make it? If yes, how should I do?
oh so I do not need excel vlookup activity to run the tasks?
Thats not required. you can use LINQ to compare 2 datatable /Sheets
Thank you for your prompt reply
I face this error when I’m trying to use the above linq, how can I fix it?
Excel Process Scope: The source contains no DataRows.
I fix the above error by changing string to datatable of dtresult but it still cannot run properly and the error shows again
Can you share the error message
There is no common value in 2 columns you compare … Please check if the values n the columns