I have created a drop down list with upto 8 selections, how can I insert a numerical number(price) in an adjacent cell that depends on the selection in the drop down list.
ie each of the 8 selections have different rates.