Pull data from one sheet to another with same words

CarolannRoedl

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'.

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)