| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Building a zip code database
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!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| database to Find customer by zip code | Excel Discussion (Misc queries) | |||
| building code for an individual report | Excel Programming | |||
| Code to 'lookup' value in Access database | Excel Discussion (Misc queries) | |||
| Problem with VBA code trying to query and access database | Excel Programming | |||
| how do you break the link with MS Query - Database via code | Excel Programming | |||
Linear Mode
