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