![]() |
#1
|
|||
|
|||
![]() 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. |
![]() |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
mruk6823 | Excel | 1 | 04-11-2017 09:25 PM |
![]() |
meggenm | Excel | 3 | 01-28-2016 10:18 AM |
![]() |
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 |