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!!
|