Building a zip code database

R

Rob

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

Tom Ogilvy

Look in Excel Help at the Vlookup worksheet formula.

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

as an example.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

New to Userforms - need return value in a cell 1
Need Help Filtering Duplicates in Excel 1
Drop Down that returns value in same table 5
How do I find all zip codes from the web? 4
Compute Tax? 0
Copy specific cells to another tab 6
Auto Populating city, state and county based on the zip code. 1
IF function that searches a range of cells for data and provide tr 2

Top