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