Drop down table

  • Thread starter Thread starter RB
  • Start date Start date
R

RB

Hello,

I have 2 columns; first column is the code and the second one is a
description of the code.

I am trying to create a dropdown list on a seperate sheet so that when
I select the code, it should return the description.

I used the combo box to create the drop down list with the code and
the description as the input range and wrote a vlookup to return the
value in that box. But, it's not returning the proper value.

Any clues?

RB
 
Hi RB,

If I understand correctly, try this.

On sheet 1 select the codes and name them CODE.
On sheet 1 select the codes and the descriptions and name it DATA.

On sheet 2 select F1 and then Data > Validation > Allow > List > Source
=CODES > OK.
On sheet 2 in C1 enter =VLOOKUP(F1,DATA,2,0)

Select from the drop down list in F1 and C1 returns the description.

HTH
Regards,
Howard
 
Back
Top