Sign in with
Sign up | Sign in
Your question

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

  • Office
  • Excel
  • Spreadsheet
  • Job Market
  • Apps
Last response: in Apps General Discussion
January 2, 2011 4:44:31 PM

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!

More about : excel find copy value2 based value1 spreadsheets

January 20, 2011 10:46:01 AM

Can you please attach some sample file for more details.