Hi Greg

You need to set the 4th argument of the Vlookup to be False or 0 instead of
True, in order to find an exact match if the data is not in sorted order.
also, you should be looking up a single cell, not a range of cells

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

--
Regards
Roger Govier

"Greg" wrote in message
...
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!