View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sdj78 sdj78 is offline
external usenet poster
 
Posts: 2
Default 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!!!