You need to have unique key values - think along the lines of SSN's.....

HTH,
Bernie
MS Excel MVP


"ETC" wrote in message
...
I have two files (one a different sourced subset of the other) and have put
last name in a column in each as the key field. The next column has First
name on one file and first middle initial on the other. Need to use a
vlookup but how do you do it across the same last name? Can I use a secondary
field; first name, location etc. to resolve to the right one?