How to match rows in two different excel sheet and copy-paste data?

Hi everyone,

I am working with two excel sheet and I need to match the ‘Fullname’ from excel 1 to excel 2 and find the row number in excel 2. After finding the row number I have to copy the ‘Location’ from excel 1 and paste it in excel 2 in the same row. Can anyone help me with this?

Use Join data table activity and remove unwanted columns.

hi sabreen

please provide me two test excel files.

Thank you

1 Like

Hi @praneeth.peyyeti, Thanks a lot for your support. I was able to create the workflow yesterday and it’s working fine now :slight_smile:

please feel free to share the solution here so that others can benefit from it and mark the question as closed :slight_smile: