Reply to thread

Message

[QUOTE="Johno, post: 3278012"]
I maintain a database log to track changes in contact data.  The log contains
last names in column B, first names in column C and ID# in column D .  I also
have a master list (Last Name, First Name and ID#) of all workers which I
have pasted into columns AA, AB and AC.  I would like to be able to have a
formula in column D which searches the master list for the matching first and
last names and returns the ID number in column C or a "?" if there is no
match.  The formula below, which I have used to successfully search for last
names works unless there are two last names the same.   I know I need an AND
in there to search for first names also but I don't know where (or how) to
put it.

=IF(ISNA(INDEX(AC$1:AC$9999,MATCH(B10,AA$1:AA$9999,FALSE))),"?",(INDEX(AC$1:AC$9999,MATCH(B10,AA$1:AA$9999,FALSE))))

Database Log
Master List
B            C           D
AA         AB          AC
Last       First        ID#
Last        First       ID#

Smith      John       ?
Blake        Tod      12056
Jones       Mary      ?
Jones        Mary     65749
Blake        Tod       ?
Park         Judy      54682
Park         Judy       ?
Smith        John     34628

I would appreciate some help.  I am using excel 2007

johno
[/QUOTE]

Verification