LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 331
Default Problem with VLOOKUP Results.

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum results of VLOOKUP Dewayne Excel Worksheet Functions 7 November 28th 07 04:53 PM
vlookup results in 0 sveazie Excel Discussion (Misc queries) 6 July 17th 07 09:20 AM
Vlookup with two results Luke Excel Discussion (Misc queries) 2 March 22nd 07 05:41 PM
to sum up all value results from VLOOKUP Linn Excel Worksheet Functions 1 March 7th 07 02:45 AM
how do you add vlookup results? Anna Excel Worksheet Functions 3 March 26th 05 03:05 AM


All times are GMT +1. The time now is 08:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"