Sunday, 14 July 2019

Comparing columns in two different excel sheets and if they match copying third column

I have limited working knowledge of Excel and I hope someone will be able to help me with my problem.


I have two different work sheets (say F1 and F2) with last name in Column A, first name in Column B. The email address are present in Column F of F2. I need to compare the names and if the names match I need to copy the corresponding email address in to F1.


Thank you

No comments:

Post a Comment

How can I VLOOKUP in multiple Excel documents?

I am trying to VLOOKUP reference data with around 400 seperate Excel files. Is it possible to do this in a quick way rather than doing it m...