Formula for adding value to column in one sheet if reference is made

Trafford Brown

Looking for help with a formula!

I have 2 sheets - Production Workforce and Production Totals.

We work by job numbers, so would like to have the calculated workforce days from "Production Workforce" appear in the "Production Totals" sheet if a job number reference is made.

Any ideas?!

Larry

I think what you are looking for is an index match with cross sheet references. This would be the formula you out in Workforce Days Column in the "Production Totals" sheet.

=INDEX({Workforce Days}, MATCH([Job #]@row, {Job #}, 0))