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
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 486 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 498 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!