asked on

How to compare 2 columns in 2 different sheets in Excel 2010?

For example:

In sheet1 I have 2 columns:

Alan Boh
Juli Ghi

In sheet2 I have 3 columns:

John Beck 53
Alan Bho. 32
Eric Guy 45

I want to compare first name and last name from sheet1 with sheet2 and if result is the same I want to take the users age in 3th columns of sheet2 and copy the value to 3th column in sheet1.

I'm not to familiar with Exel formula...so need help:-)

Thanks in advance.

ASKER CERTIFIED SOLUTION

Professor J

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

cri

One of the best sites for helping you with this kind of Tasks I happen to know and appreciate since long is http://www.cpearson.com/excel/topic.aspx

SOLUTION

zalazar

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SAM2009

ASKER

Thank you very much for the explanation. That's the first time I see INDEX formula. Could we do the same thing with VLOOKUP?

SOLUTION

Subodh Tiwari (Neeraj)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Professor J

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

zalazar

Below please find a link to the Microsoft website where they explain VLOOKUP and INDEX/MATCH. They also explain the limitations of VLOOKUP.
https://support.microsoft.com/en-us/kb/181212

SAM2009

ASKER

Thanks everybody for your help.