I want to be able to assign a value to each item in a dropdown list, and have
that value appear in another cell when item is selected.
Example:
Items in dropdown list (Cell A1):
boiler 1
boiler 2
boiler 3

boiler 1 is $2,000, boiler 2 is $3,000 and boiler 3 is $4,000
Cell A2 would display $ value of A1
if boiler 2 is selected from list in A1, A2 would show the value $3,000

thanks for your help,
Matt