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 ...
To force Excel to look for an exact match, specify FALSE as 4th argument to VLOOKUP:
=VLOOKUP(B6,J9:K28,2,FALSE)
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!