How can i get 1 value to display another value when selected
 

In my excel worksheet i have a drop down menu that displays codes, but i also
have the meaning of that code in another column. I want to be able to select
the from the drop down and it shows the correlating definition in the
adjacent cell. any clue on what formula can do this. thank you

How can i get 1 value to display another value when selected
 

Six Sigma Blackbelt wrote:
In my excel worksheet i have a drop down menu that displays codes, but i also
have the meaning of that code in another column. I want to be able to select
the from the drop down and it shows the correlating definition in the
adjacent cell. any clue on what formula can do this. thank you

Assuming your codes are in A1:A10 and your meanings are in B1:B10 and the drop
down is in C1 put the following in D1:

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

How can i get 1 value to display another value when selected
 

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





"Glenn" wrote:

Six Sigma Blackbelt wrote:
In my excel worksheet i have a drop down menu that displays codes, but i also
have the meaning of that code in another column. I want to be able to select
the from the drop down and it shows the correlating definition in the
adjacent cell. any clue on what formula can do this. thank you

Assuming your codes are in A1:A10 and your meanings are in B1:B10 and the drop
down is in C1 put the following in D1:

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

How can i get 1 value to display another value when selected
 

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)