Cross-Sheet References with Contacts


I don't know if what I'm trying to do is not possible within the application or if I'm just missing something. I have created a form that the user selects their name from on the dropdown list. On the corresponding sheet, I'd like to populate their email address and office code by using a master contact list in a different sheet that contains the name, email, and office code for each person. I think I need either use the VLOOKUP or INDEX formula but not sure what the actual formula language would be to get it to work.

Any help would be greatly appreciated.

Thank you,

Chris Hockey


  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi Chris,

    It works, and you are on the right track. We would use a VLOOKUP or a combination of INDEX/MATCH to make it work.

    Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too,

    I hope that helps!

    Have a fantastic weekend & Happy Holidays!


    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

    ✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: | | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.