Help needed 2 Data validation scrollmenu's Variable outcome equals price

[John Dillinger]

Hello everyone,

I have had my brains cracking over an overview i am trying to create for work. I've searched everywhere but can't seem to find any forums on how to actually make it.

Maybe one of you can provide me with an awnser or with a actual sum on how to make it work. The last would help me the best so I can continue on developing the sum on my own, or with the help of u guy's..

Anyway this is what i am trying to do:

http://imgur.com/a/97Kxo

 

[vletm]

@John Dillinger
It would be much much much better to send Excel-file here.
It would be too tricky for You if I would send screenshot back?

 

[John Dillinger]

Hey vletm,

Thank you for your reply..

@John Dillinger
It would be much much much better to send Excel-file here.
It would be too tricky for You if I would send screenshot back?

Like this?

 

[vletm]

Yellow Cells...

 

[John Dillinger]

Yellow Cells...

That's is just great!

Thank you so much!