View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken G. Ken G. is offline
external usenet poster
 
Posts: 37
Default Dynamic Data Validation List

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.