Can I copy a field from another spreadsheet based on search?

[Faye]

I have two spreadsheets each storing data about jobs we need to manufacture.

Spreadsheet A stores operation #1 and the workcentre it will be performed
at, Spreadsheet B stores operation #2 and the workcentre that will be
performed at.

Not all jobs are in both Spreadsheet A&B, but for each job that is listed in
both spreadsheets I need to put the workcentre from operation #2 in a new
field (workcentre2) in Spreadsheet A, in the proper row for that job.

Can this be done?

Thanks for any advice,

 

[Pete_UK]

You can use VLOOKUP to do this - Debra Dalgleish has some
comprehensive notes here:

http://www.contextures.com/xlFunctions02.html

Hope this helps.

Pete

 

[Faye]

Thanks Pete that looks very promising. I appreciate your help!
Faye

 

[Pete_UK]

You're welcome, Faye.

Pete