Pull data from one sheet to another with same words

Hello,

I am fairly new to SmartSheets - I am trying to figure out how to pull data from one sheet to another that would have a names in common.

I.E. Sheet 1 has a course name of Smith AR Training. Sheet 2 has the Region Name as Smith in one column and then a contact person in the 2nd column. Because Smith is listed in both sheets, how can I pull the contact person onto Sheet 1 by using the common name of 'Smith'.

Find more posts tagged with

Education

Formulas

Community Platform

Comments and Conversations

Cell linking

Accepted answers

All comments

Kaveri Vipat

Hi CarolannRoedl

Hope you are doing well.

Please try this one - =INDEX({Contact}, MATCH(Name@row, {Name}, 0))

Also, You can see the below Screenshots for a better understanding.

Sheet 1

Sheet 2

Have a Good Day!

CarolannRoedl

Hi Kaveri,

Thank you so much for your response! I apologize, the course name is 'Smith AR Training', I have provided screen shots to shows as an example. Within the formula, I believe I would reference Sheet 2.

Sheet 2.jpg

Sheet 1.jpg

Gia Thinh

Hi, I sugest a development from Kaveri's INDEX formula as below:

Sheet 1 : =INDEX(COLLECT({Course Contact}, {Region}, CONTAINS(@cell, [Course Name]@row)), 1)

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.