ExcelBanter - Comparing two lists using two columns from each spreadsheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Comparing two lists using two columns from each spreadsheet (https://www.excelbanter.com/excel-worksheet-functions/184069-comparing-two-lists-using-two-columns-each-spreadsheet.html)

Comparing two lists using two columns from each spreadsheet

How can i compare two lists using two columns from each spreadsheet. E.g in
the first list I have two columns with Last Name and First Name, in the
second list I have three columns, Employee ID#, Last Name and First Name.
Since i have lot of employees with the same last name, I'm trying to compare
these two list by Last name and First name at one. Please help!!!

Comparing two lists using two columns from each spreadsheet

Vlookup or Index/Match should do it for you:

http://www.contextures.com/xlFunctions02.html

http://www.contextures.com/xlFunctions03.html

If you are not comfortable with those, use an Access query. Access will do
this for you quickly and easily!

Regards,
Ryan--

--
RyGuy

"sdj78" wrote:

How can i compare two lists using two columns from each spreadsheet. E.g in
the first list I have two columns with Last Name and First Name, in the
second list I have three columns, Employee ID#, Last Name and First Name.
Since i have lot of employees with the same last name, I'm trying to compare
these two list by Last name and First name at one. Please help!!!