View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Building a zip code database

Look in Excel Help at the Vlookup worksheet formula.

=if(zipcodecell="","",Vlookup(zipcodecell,Table,2, False))

as an example.
--
Regards,
Tom Ogilvy


"Rob" wrote in message
...
I have a complete list of zip codes, cities, counties and tax rates. I am
trying to set the spreadsheet up so that when the zip code is entered then
city, county and tax rate will auto fill in their perspective and

pre-defined
cells. HELP!!