Six Sigma Blackbelt wrote:
Thanks Glenn, this will start me off, the codes & definitions are located on
sheet 2 of the workbook, which i forgot to mention. So does that change the
formula. The airport codes are in the drop down on sheet 1, below the drop
down is the definition or lanes that i want to display when i pick the
airport from the drop down.

Thank you again Glenn




Just select the range instead of typing it into the formula. Should come out
something like this:

=VLOOKUP(C1,Sheet2!A1:B10,2,FALSE)