Lookup? Match? Being driven mad...

B

Bravura

I have two worksheets. Both have a huge list of employees' names, in a first
name cell, then a surname cell. Some of the people appear on both worksheets.
I need to produce another sheet that shows every employee that exists on both
the original worksheets, plus pulling corresponding employee data from one of
the original sheets.

I can't for the life of me figure a way to do it. Any ideas?

Ben
 
B

Bob Phillips

=IF(ISNA(MATCH(1,(Sheet2!$A$1:$A$1000=a1)*(Sheet2!$B$1:$B$1000=B1),0)),"","M
atch")

To get details

=IF(ISNA(MATCH(1,(Sheet2!$A$1:$A$1000=A1)*(Sheet2!$B$1:$B$1000=B1),0)),"",
INDEX(Sheet2!$C$1:$C$1000,MATCH(1,(Sheet2!$A$1:$A$1000=A1)*(Sheet2!$B$1:$B$1
000=B1),0)))


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top