Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Comparing two lists using two columns from each spreadsheet | Excel Worksheet Functions | |||
comparing lists - i think | Excel Discussion (Misc queries) | |||
Comparing lists | Excel Worksheet Functions | |||
Comparing two lists | New Users to Excel | |||
comparing lists | Excel Discussion (Misc queries) |