Referencing a list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to figure out how to reference a list on a seperate worksheet. I
have a list of Airport Codes, with the corresponding city next to it.

On a seperate worksheet, I would like to be able to enter the three-letter
airport code, and have the city pop up automatically next to it.

Any advice? Thanks!
 
You could use an VLOOKUP formula to populate the city based upon the airport
code.

Assuming that the list is in Sheet2 Cells A1 through B11 and the first cell
in Sheet1 having an airport code is cell A1.

=IF(ISBLANK(A1),"",VLOOKUP(A1,Sheet2!$A$1:$B$11,2,FALSE))

If A1 is blank, put nothing, otherwise extract the value in column 2 of the
lookup table that corresponds with airport code in column A. The optional
FALSE argument forces and exact match instead of an approximate one.
 
Thank you very much, Kevin B and RagDyer!!! The VLOOKUP formula is EXACTLY
what I need!

You guys are the best!

Thom
 
Back
Top