Lookup? Match? Being driven mad...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bravura - 08 Nov 2006 14:00 GMT

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

Reply to this Message

Bernard Liengme - 08 Nov 2006 14:53 GMT

Visit Chip site where he has lots on duplicates: www.cpearson.com
best wishes

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

>I have two worksheets. Both have a huge list of employees' names, in a
>first
[quoted text clipped - 9 lines]
>
> Ben

Reply to this Message

Bob Phillips - 08 Nov 2006 14:57 GMT

=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)))

Signature

HTH

Bob Phillips

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

> 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.
[quoted text clipped - 5 lines]
>
> Ben

Reply to this Message

Rate this thread: