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

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

Hope this helps.

Pete

On Jul 14, 9:46*pm, Faye wrote:
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,