Pull data from one sheet to another with same words



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


    Kaveri Vipat

    Senior Associate - Smartsheet Development, Ignatiuz Software

    2023 Core Product Certified

    Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️"

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

  • Gia Thinh
    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)

    Gia Thinh Technology Co., LTD - Smartsheet Solution Partner.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!