VLOOKUP with contacts - contact name appears but not the associated info
I have a sheet where I am using VLOOKUP in a contact column to pull in the associated project manager based on a date. The VLOOKUP is your standard formula:
=VLOOKUP($[Target Date]$5, {Launch Date}, 3, false)
The reference table is at column 3 is also a contact column and the project managers in this column have their email info, etc showing up like you would typical expect for a contact column. My VLOOKUP column, however, is only pulling in the person's name and doesn't seem to recognize them to have their email. This is limiting my ability to setup workflows on the new sheet.
Anyone have any ideas what I'm doing wrong?
what I see in my new contact column with the vlookup:
This is what my contact looks like in the sheet I'm referencing in vlookup:
Best Answer
-
I'm unable to replicate this... can you check some of the other settings?
It shouldn't make a difference, but can you ensure that both columns properties are set up the same, that both either have Allow Multiple Contacts checked or unchecked?
Also, are the contact values listed in the column properties? (Again, it shouldn't make a difference, but I'm interested to see if it will change the output.)
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Make sure your vlookup column is a contact column as Well.
-
both columns are formatted as contact columns and it's still not pulling in the contact info.
-
I'm unable to replicate this... can you check some of the other settings?
It shouldn't make a difference, but can you ensure that both columns properties are set up the same, that both either have Allow Multiple Contacts checked or unchecked?
Also, are the contact values listed in the column properties? (Again, it shouldn't make a difference, but I'm interested to see if it will change the output.)
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
@Genevieve P you figured it out! It was the Allow Multiple Contacts that was different. Checking that in the sheet with the VLOOKUP formula fixed it and now the contacts are pulling in as they should. Thank you for your help!
-
Aha! I take it back, it does make a difference!
Glad we figured it out. 🙂
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!