#1
|
|||
|
|||
Enter a city based on a short list of zip codes
I have a small table of zip codes and cities. I'd like a long membership list to pick up the city name based on the zip code. Is this a VLOOKUP, or is there something else more appropriate? Thanks.
|
#2
|
||||
|
||||
Depending on the order of the columns in your table you can use VLOOKUP or INDEX/MATCH.
The Index/Match will work no matter the order, so safer to use that. e.g. =INDEX($B$2:$B$100,MATCH(X2,$A$2:$A$100,0)) where A2:A100 contain the Zip codes and column B has the Cities, X1 contains the Zip code to look up. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
alt+enter issue , short cut not working | mruk6823 | Excel | 1 | 04-11-2017 09:25 PM |
Move Data from Master List to Sheets with City Name | meggenm | Excel | 3 | 01-28-2016 10:18 AM |
enter a constant based on entered number | So New2 This | Word VBA | 1 | 10-17-2014 05:29 AM |
Programming based on an enter key event | edayers315 | Word VBA | 0 | 06-11-2010 09:57 AM |
Is there a way to do this? (automatically enter text based on form data) | TIKKI555 | Word | 0 | 05-26-2010 09:21 AM |