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

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?!

Find more posts tagged with

Formulas

Accepted answers

All comments

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))

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.