Vlookup email name return name
If I enter email from drop down list in PDCA, match that to column 3 on email worksheet and return the name to the left in PDCA Person Responsible.
Answers
-
Hi @Brandon03
The values that you're matching across sheets will need to be the same type of value. For example, I can see that in your top screen capture the email is in a Contact Column, but in the bottom screen capture the emails are typed into a Text/Number type of column.
You will want to standardize these two columns (either both are Text emails, or both are Contact type of values) in order for the VLOOKUP to successfully bring back the name. See: Column Type Reference
Once you've set up your columns to be matching, I would actually suggest an INDEX(MATCH formula over VLOOKUP.
An INDEX(MATCH works like this:
=INDEX({Column with value to return}, MATCH([Value to match]@row, {Column with value to match in the other sheet}, 0))
Let me know if this makes sense and if it works for you!
Cheers,
Genevieve
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.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!