match name fields to determine differences

  • Thread starter Thread starter DJH
  • Start date Start date
D

DJH

I have two worksheets that have common columns for last name and first
name. I want to determine which rows are in both worksheets based on
the last name and first name. The concatenate function with vlookup
is an option, is there an easier way?
 
I will have to assume that first names are in column A and last names in
column B.
And that there are 300 names on sheet1 with headings.
The first sheet is called "sheet1"
It doesn't matter how many names are on sheet 2.
In the second sheet cell C2 enter
You may have to change it around to match your information.

=IF(SUMPRODUCT((Sheet1!A$2:A$301=A2)*(Sheet1!B$2:B$301=B2))=0,"original","exist")

Copy/fill the formula down as far as you need. It will tell you if the name
exists on sheet1

Regards
Steve
 
Back
Top