drop lis

[devilonline]

Hi,

I have this excel with a drop list. how can i do this

if i chose 1 the result in the next row is tree. if i chose 2 the result in the next row is sun.and so one


thanks

[AliGW]

What????

The attached sheet bears no relation to trees and suns ... Please explain very clearly what you want to do, what the result should be and where it should appear.

[devilonline]

???????????

i have a drop list. if i chose the first choice it shows in the row below the result a sentence a number anything.

thanks

[AliGW]

???????????

i have a drop list. if i chose the first choice it shows in the row below the result a sentence a number anything.

thanks

There is no drop-list that I can locate on the sheet - where do you think it is???

[devilonline]

the drop list is on sheet1 D2

[shg]

There is no data validation in that workbook.