drop down boxs with diff vaules

R

rl71066

1st i would like to thank the people who help me with my last question i
never thought to use IF thank you for setting me on the right path.

next ?

i want to use a drop down box with differnt names with diff values. like this
apples=2 pears=4
oranges=5 then in other row * them by amount
like you pick apples which are 2 x by 5 ( next row ) then the amount.

it might be simple but im lost.

thanks again for everybodys help
 
Top