How to return a contacts phone number from another sheet?


I am trying to create a master contact list, so that a user can assign a contact to a task in any project sheet. When they assign a contact in their project, the next column should return a telephone number, using VLOOKUP, against my master contact list.

Any help? :)


  • Kimberly Loveless
    Kimberly Loveless ✭✭✭✭✭✭

    I think that you would just have to set the VLOOKUP formula when setting up each sheet and then make it a column formula. It is pretty easy to do.

    We actually have a contact list that utilizes similar logic on many of our sheets, but we actually use the INDEX/MATCH formula instead of VLOOKUP so that if we decide to restructure or add fields to the contact list it doesn't mess up the formula. What is ends up looking like is something like =INDEX({Phone #},MATCH([Assigned Contact]@row, {Employee Name},0))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!