SOLVED

Vlookup referencing a cell with drop down selections

Copper Contributor

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?

2 Replies
best response confirmed by Kathleen99 (Copper Contributor)
Solution

@Kathleen99 

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!
1 best response

Accepted Solutions
best response confirmed by Kathleen99 (Copper Contributor)
Solution

@Kathleen99 

To force Excel to look for an exact match, specify FALSE as 4th argument to VLOOKUP:

 

=VLOOKUP(B6,J9:K28,2,FALSE)

View solution in original post