| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP Formula Returns the Wrong Results.
-- I am always thankful for the help everyone gives me. Virtual Drinks for all! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP Formula Returns the Wrong Results.
Sorry, submitted post before entering issue.
----------- Col A has the airport codes and my table array has the airport codes decoded. The formula I used should have returned the decoded airport city of ABE - Allentown, PA, USA Allentown Bethlehem Easton Airport, 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! "Greg" wrote: -- I am always thankful for the help everyone gives me. Virtual Drinks for all! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP Formula Returns the Wrong Results.
This is the formula I used:
=VLOOKUP($A$2:$A$2544,'AIRPORT CODES'!$A$2:$A$2989,1) "Greg" wrote: -- I am always thankful for the help everyone gives me. Virtual Drinks for all! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
VLOOKUP Formula Returns the Wrong Results.
see response to your other posting in excel.new
Please refrain from posting the same question to multiple groups. Most of the regulars scan all of the groups and your question will get picked up. Posting to multiple groups results in time wasted answering questions that have already received an answer. -- Regards Roger Govier "Greg" wrote in message ... This is the formula I used: =VLOOKUP($A$2:$A$2544,'AIRPORT CODES'!$A$2:$A$2989,1) "Greg" wrote: -- I am always thankful for the help everyone gives me. Virtual Drinks for all! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup Returns Wrong/No Data | Excel Worksheet Functions | |||
| SUM formula results returns 0 value | Excel Worksheet Functions | |||
| Same formula referencing same cells returns incorrect results, randomly, when pasted into new worksheet | Excel Worksheet Functions | |||
| Array formula returning wrong results | Excel Discussion (Misc queries) | |||
| Excel 2002 Lookup formula returning wrong results? | Excel Worksheet Functions | |||
Hybrid Mode
