| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Vlookup Table Help
Revisiting an eariler issue.
I have an excel document that looks like what I've shown below, in Sheet 1 Column A Column B Column C Column D 1 Origin Airport Destination Airport City Name Airline 2 ABE 3 ABQ 4 ACE 5 ABI I am trying to create a Vlookup table that will decode the origin airport code in Col A and display the decoded code with the city name in Column D. In Sheet 2, my table array I have created looks like this. Column A Column B 1 Airport Codes City Code 2 ABE Abilene, TX, USA Municipal 3 ABQ Albuquerque, NM, USA Albuquerque International Airport 4 ACE Lanzarote, Canary Islands, Spain Lanzarote 5 ABI Abilene, TX, USA Municipal The formula I'm using is =VLOOKUP(A2,'AIRPORT CODES'!$A$2:$B$2989,2,1) and I'm getting the wrong answer, ( Albacete, Spain Albacete Airport) when the answer should be Allentown Bethlehem. How do I correct this? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Vlookup Table Help
Sorry, in my sentence where I state the answer should be Allentown Bethlehem,
should actually be Abilene, TX, USA Municipal. This has been a thorn in my side issue all day. "Greg" wrote: Revisiting an eariler issue. I have an excel document that looks like what I've shown below, in Sheet 1 Column A Column B Column C Column D 1 Origin Airport Destination Airport City Name Airline 2 ABE 3 ABQ 4 ACE 5 ABI I am trying to create a Vlookup table that will decode the origin airport code in Col A and display the decoded code with the city name in Column D. In Sheet 2, my table array I have created looks like this. Column A Column B 1 Airport Codes City Code 2 ABE Abilene, TX, USA Municipal 3 ABQ Albuquerque, NM, USA Albuquerque International Airport 4 ACE Lanzarote, Canary Islands, Spain Lanzarote 5 ABI Abilene, TX, USA Municipal The formula I'm using is =VLOOKUP(A2,'AIRPORT CODES'!$A$2:$B$2989,2,1) and I'm getting the wrong answer, ( Albacete, Spain Albacete Airport) when the answer should be Allentown Bethlehem. How do I correct this? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Vlookup Table Help
Think all that's needed is to make it search for an exact match:
=VLOOKUP(A2,'AIRPORT CODES'!$A$2:$B$2989,2,0) (use 0 as the 4th param, instead of 1) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup table | Excel Discussion (Misc queries) | |||
| Table with VLOOKUP? | Excel Discussion (Misc queries) | |||
| Finding a vlookup table | Excel Worksheet Functions | |||
| VLOOKUP - 3 Table Array | Excel Worksheet Functions | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Linear Mode
