Dynamic Data Validation List
Assume your table is in the range A1:B15
D1 = zip code
Source for the drop down list:
=OFFSET(B$1,MATCH(D$1,A$1:A$15,0)-1,,COUNTIF(A$1:A$15,D$1))
Biff
"Ken G." wrote in message
...
I want to be able to enter a Post Code (Zip Code) in a cell and then using
the Vlookup function find the first occurence of that in the post code
list
(sorted by code), then find the last occurence, and use these two values
as
the start end end points for a data validation list so that the user can
select the desired location from the list of locations having the same
post
code.
|