I have two excels. And I want to match excel1 several colunms data from the excel2 based on comparing the same colunms between excel1 and excel2. How can realize that?
example for excel1
example for excel2:
purpose: if “Name” in excel1 equals “Name” in excel2, than fill “remark” data from excel2 to excel1.
it similar like formula “Vlookup”.
did you try to use below activity?
It is returning the list of cells addresses, in which wanted value was found.
E.g.: output(0) will be “$A$1”.
Then you can use For Each activity to loop through whole list and write cell in places, you want.
thank you. But i have doubt about your activity. could you please give me more detail? hope kind reply. :脸红:
i use the “Vlookup” formula like
Try using a primer where you have a formula populated already and you just read the result.
VlookupExample.xlsx (14.2 KB)
Check the sheet named “Primer” in the file attached
Step 1 Place the primer in your sheet
Step 2 Write the name value in A2 and read B2(this will be populated with remark if value is found)
Step write the value of B2 into the required excel
I want to remain excel1 all cells but only need “remark” which matched in excel2 based on “name” is equal between two excels. thank you.
VlookupExample (1).xlsx (12.0 KB)