Bee, I had a similar problem and resolved it by sorting the lookup i.e in
your example, the zip codes.

"kbee" wrote:

seen in the function's window, what is missing?
=vlookup(F2,AG2:Ah24,2) i tried to add at the end true or false but it does
not work. ??
f2=zip code
ag column =list of zip
ah=name of city=2
thanx for the solution.
bee