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.