One way:

Try this array formula** :

=INDEX('Addresses-Main Data Sheet'!A1:K1000,MATCH(A1&B1,'Addresses-Main Data
Sheet'!A1:A1000&'Addresses-Main Data Sheet'!B1:B1000,0),3)

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

If the data to be returned is numeric and the names (first last) are listed
only once in the lookup sheet we can use a less complicated non-array
formula.

Biff

"Claudio Funes" wrote in message
...
I'm trying to read employee's records, and I have lots of Bobs and others,
but different last names on the following column. The question is: how do
I
make it read the next column to match the last name to extract the
information for that row? I can't just use the second column because there
some same last names.

This is what I have right now, where $A1 is the first name, and naturally
the last name is B1.

=VLOOKUP($A1,'Adresses-Main Data Sheet'!$A$1:$K$1000,3,0)

Thanks for your help.