Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula?
I use ms Excel for my invoices. I service about 10 different zip codes. I
want to be able to enter the zip code in one field and have excell automatically insert the corasponding city name in the designated field. What is the formula for that? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula?
Use VLOOKUP. Create your list of zip codes and cities on a tab used for just that list. -- rsenn ------------------------------------------------------------------------ rsenn's Profile: http://www.excelforum.com/member.php...o&userid=29050 View this thread: http://www.excelforum.com/showthread...hreadid=511390 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula?
Use a sheet for this purpose, rename it to, say, ZIPCITY.
Column A:A contains your zips. Column B:B contains the corresponding city. Back in your invoice sheet, assume zip is in D2. Use: =VLOOKUP(D2, ZIPCITY!A:B, 2, 0) HTH Kostis Vezerides |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
2 Nesting questions | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |