If the first and last names are in separate cells try something like this:

This data on Sheet2 A1:C4

Shmo...Bill...data
Shme...Frank...data
Shmuck...Ty...data
Shmo...Joe...data

Lookup Joe Shmo...

A1 = Shmo
B1 = Joe

Array entered** :

=INDEX(Sheet2!C1:C4,MATCH(1,(Sheet2!A1:A4=A1)*(She et2!B1:B4=B1),0))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"Teric506" wrote in message
...
Hello,

I have two worksheets that I am trying to create a lookup for. They both
have id #'s columns that should be the same so I tried to do a vlookup
only
to discover they are not the same. The only colomns on both sheets that
are
the same are first and last name. I need them both becasue some many
people
have the same last name but different first names and so forth. So what I
am
trying to do is take joe shmo in sheet 1 and return the data for joe shmo
that resides in sheet 2. I cant for the life of me figure out how to do
this.
Does anyone have any ideas?? Thanks so much.

Teri