Validation List
Create a helper table in an unused part of your sheet, in my example G1:I3
G H I
1 drinks food clothes
2 water cakes hat
3 coke chocolate gloves
and insert in the Source field of the Valiadation/List dialog the following
formula:
=IF(A1=$G$1,$G$2:$G$3,IF(A1=$H$1,$H$2:$H$3,$I$2:$I $3))
Regards,
Stefi
€˛Dilip Mistry€¯ ezt Ć*rta:
Hi
Is it possible for the following:-
Create a validation in Cell (A1) with list of Drinks, Food, Clothes
Depending on what is selected the Validastion in cell (B1) will display
Coke, Water if Drinks in chosen in A1, Cakes, Chocolate if Food is chosen
and Hat , Glove if Clothes is chosen in cell A1
I hope I have given enough information
Thanks in advance
|