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

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,

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

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,

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

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

"Pete_UK" wrote:

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,

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

You're welcome, Faye.

Pete

On Jul 15, 2:50*pm, Faye wrote:
Thanks Pete that looks very promising. *I appreciate your help!
Faye