Dropdown list

[Goodstart14]

Hi,
I'd like to make dropdown lists for several cells.
For example, I got a list like below in Sheet1;
A B
1 X $ 4
2 Y $ 5
3 Z $ 6

In B5 Sheet2, I want to add this dropdown and choose the column A but I need the records in the column B.

A B C D
5 X 13 Formula here <----- (=B5*C5)

The value (X,Y,Z) will change, so I don't want to change each cells in the future. I want to change only the dropdown list.

How can I do that?
Thanks

[stnkynts]

It is hard for me to tell which columns are what and if rows are row numbers or values. Definately would have been best for you to submit an example workbook. Here is my best guess with what you submitted.

Please Login or Register  to view this content.

[Goodstart14]

Thanks, I'll study with this.