I would like to create a drop down list that when a specific choice is made
changes the cell next to it according to the relationship of the choice.

For example. I have chicken at $2.50 a pound. It cost $45.00 a case. In
my list, I want to be able to choose a drop down that says pound, and in the
cell next to it, it changes to $2.50. If I change it to case, it changes the
price cell to $45.00 a case. Is this possible?

Thanks for you help.
Russ

In cell C1 put Pound - D1 put 2.50
in cell C2 put Case - D2 put 45

assumed cell A1 has drop down list in b1 put this formula =vlookup
(a1,C1:D2,2,0)




On Dec 10, 1:57*am, Russell Johnson
wrote:
I would like to create a drop down list that when a specific choice is made
changes the cell next to it according to the relationship of the choice.

For example. *I have chicken at $2.50 a pound. *It cost $45.00 a case.. *In
my list, I want to be able to choose a drop down that says pound, and in the
cell next to it, it changes to $2.50. *If I change it to case, it changes the
price cell to $45.00 a case. *Is this possible?

Thanks for you help.
Russ