Drop Down List & VLOOKUP - getting wrong data

  • Thread starter Thread starter joannanpa
  • Start date Start date
J

joannanpa

I've created a drop down menu in cell A1 by referencing an arra
"ADDRESSES", which is a single list of addresses.

I created a VLOOKUP for the owner's name to automatically show up i
cell B1. [VLOOKUP(A1, HOMELIST, 2)

Problem: this has worked for half the homes (all Main Stree
addresses). Once I try to start with Town Road homes, I get the wron
owner information inserted.

The addresses are listed alphabetically by address, as an example:

1 Main Street
5 Main Street
2 Town Road
3 Town Road

Could this be part of the problem?

Any help is greatly appreciated
 
Use exact match

VLOOKUP(A1, HOMELIST, 2,0)

that way you would know when there is no match, that can depend on
for instance hidden spaces or other characters.
 
There are 2 forms of VLOOKUP :-
=VLOOKUP(A1, HOMELIST, 2,TRUE)
=VLOOKUP(A1, HOMELIST, 2,FALSE)

Because you have left out the final argument, it uses the TRUE versio
which requires that the lookup column be sorted in ascending order. Th
VLOOKUP returns the first *approximate* match that it comes to. If yo
want to use Town Road, you will need to sort this column.

The FALSE version of VLOOKUP does not require a sorted list because i
returns an exact match or #N/A if not found
 
Back
Top