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? :)
Help Article Resources
Check out the Formula Handbook template!