Pull data from One Sheet into another based upon criteria

I have one sheet that has address information for employees. I am creating another sheet where I would like to pull in the address of the employee based upon the name that is entered within a specific cell.

For example: in Sheet 2 you see Name Test and below I would like to pull from Sheet 1 that specific address for the name that is listed.

Contractor Sheet (Sheet 1)

Finance (Sheet 2)

Find more posts tagged with

Accepted answers

Paul Newcome

You would use something along the lines of

=INDEX({Reference Sheet Address Column}, MATCH([Primary Column]5, {Reference Sheet Name Column}, 0))

All comments

KPH

Hi @Angela L

A combination of INDEX and MATCH (if you just want to match on Name) or INDEX and COLLECT (if you want more than one thing to be considered when you match) will do this for you.

https://help.smartsheet.com/function/index

https://help.smartsheet.com/function/match

https://help.smartsheet.com/function/collect

Are you familiar with cross sheet references?

https://help.smartsheet.com/articles/2482644-create-cross-sheet-references

Angela L

Thank you for the information, but I am still struggling how to create the formula. The address is listed on a different sheet where I created the reference, but unsure the text for the formula.

Paul Newcome

You would use something along the lines of

=INDEX({Reference Sheet Address Column}, MATCH([Primary Column]5, {Reference Sheet Name Column}, 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.