Forum Discussion
Solved
Vlookup referencing a cell with drop down selections
Please see attached .
Cell B6 provides a drop down list of locations. I am trying to return the appropriate email address in cell G6 by using a vlookup function. It works, inconsistently, and I'm not sure why. I have unhidden the array table in columns J&K for reference. Does anyone have any ideas?
To force Excel to look for an exact match, specify FALSE as 4th argument to VLOOKUP:
=VLOOKUP(B6,J9:K28,2,FALSE)
2 Replies
To force Excel to look for an exact match, specify FALSE as 4th argument to VLOOKUP:
=VLOOKUP(B6,J9:K28,2,FALSE)
- Wow, so simple. Thank you so much, that worked perfectly!
