Pulling info from another sheet using pre-defined row and column labels/inputs

Looking for a formula and stuck. Not sure if vlookup, match, index, or a crazy combination of each.

I have a metrics sheet where I want to pull in the number of hours from a another sheet. The source sheet I need to pull from has hours for each month listed (2nd screenshot). However, the source sheet has 3 sets of hours for each month based (different columns, standard, OT, etc).

Now, my metrics sheet has "labels" for the month and the columns that will be used in the formula (1st screenshot). I want this in order to manually change the labels at will and still search the source sheet to pickup the proper number of hours.

How in the world to I write a formula for this?

Find more posts tagged with

Accepted answers

All comments

Intern98

=IF(

(CONTAINS([Label]@row,(REFERENCE RANGE 1))=True),

(VLOOKUP([Label]@row,(REFERENCE RANGE 2),5,false)),

"")

Where reference range 1= [Month]:[Month]

, reference range 2= [Month]1:[Standard]X

Do click, reference other smartsheet, the second smartsheet and select the range accordingly

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.