Jun 06 2021 11:40 AM
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?
Jun 06 2021 11:57 AM
SolutionTo force Excel to look for an exact match, specify FALSE as 4th argument to VLOOKUP:
=VLOOKUP(B6,J9:K28,2,FALSE)
Jun 06 2021 12:02 PM
Jun 06 2021 11:57 AM
SolutionTo force Excel to look for an exact match, specify FALSE as 4th argument to VLOOKUP:
=VLOOKUP(B6,J9:K28,2,FALSE)