Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
My issue is:
Col A has the airport codes (ABE) and my table array has the airport codes decoded. The formula I used: =VLOOKUP($A$2:$A$2544,'AIRPORT CODES'!$A$2:$A$2989,1) should have returned the decoded airport city of ABE - Allentown, PA, USA Allentown Bethlehem EastonAirport. Instead it returned ABC - Albacete, Spain Albacete Airport. Can anyone tell me what I'm doing wrong? -- I am always thankful for the help everyone gives me. Virtual Drinks for all! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sum results of VLOOKUP | Excel Worksheet Functions | |||
vlookup results in 0 | Excel Discussion (Misc queries) | |||
Vlookup with two results | Excel Discussion (Misc queries) | |||
to sum up all value results from VLOOKUP | Excel Worksheet Functions | |||
how do you add vlookup results? | Excel Worksheet Functions |