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? :)
Answers
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!