Excel - find and copy value2 based off of value1 in 2 spreadsheets


Oct 25, 2006
I have two spreadsheets in Excel. One has a list of names and a blank column next to it for their respective jobs:

Lastname -- Job (blank)

The second spreadsheet has everyone's name (but with a title in front Ex. "OT Lastname") and then a column with everyone's job:

OT Lastname -- Station 1

Is there a function that will search the completed second worksheet, find the last name and its respective job, and copy that respective job to the respective last name on the first, empty spreadsheet?

They are in a random order on the second spreadsheet, otherwise I would just copy and paste over. If only it were that easy.

Does that make sense? Thank you for your help!