Vlookup from two different workbooks

Hi, I’m pretty rusty with Excel so I’m hoping I can get some help. Thanks in advance.

Workbook A is a spreadsheet with a list of contacts. In column “L” is the rep’s last name who is assigned to that contact. In Workbook B, I have in column “a” the "contacts last name". I’d like the formula to lookup a specific rep's name and populate the contacts "last name" in that column.

For instance, Look up the rep's last name Jones in Workbook A. Populate all the contacts "last names" in this column A that are associated with Jones in Workbook B.

Hope that makes sense.

sounds like this should work -

'column to return' is a 1, 2, 3...

=vlookup(A1,'[other workbook.xls]tab name'!cell ranges,column to return,false)


however, a sample file (one file, move data to a second tab, or two files) is always helpful.