View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Looking for Answers Looking for Answers is offline
external usenet poster
 
Posts: 3
Default Matching records based on multiple columns

I need to compare records from two different sets of data.
Set 1 is a master list and Set 2 is a sublist of the master.
The comparison involves three columns from each set; Tag#, Location, S/N.
I want to be able to match records from Set 2 to Set 1, ending with an
additional column that shows if there is a match (true/false).

What is the most efficient way of completing this task? Thanks