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

"RB" wrote in message
...
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