VLOOKUP Formula Returns the Wrong Results.

[Greg]

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

Virtual Drinks for all!

 

[Greg]

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?

 

[Greg]

This is the formula I used:

=VLOOKUP($A$2:$A$2544,'AIRPORT CODES'!$A$2:$A$2989,1)

 

[Roger Govier]

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.