drop down

[Dhiyab]

Greeting all,

i am new to this excellent forum and hope to get answer to my question.

i would like to create xcel sheet that has drop down list with calculation.

column A contains fruite, vegtables, meat,...etc
column B (depends on A) if i choose in A fruite, i shall have orange, apple, banana,..etc
Column C (depends on B selection) price pe Kg
Column D (Quantaty)
Column E (fx= C*D)

i apprecaite recieving a help ASAP

[shg]

Duplicate post, thread closed. Please take a few minutes to read the forum rules.

Thanks.