VLOOKUP Formula Returns the Wrong Results.
 

--
I am always thankful for the help everyone gives me.

Virtual Drinks for all!

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!

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!

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!