Hello all,
I need some help on using functions with a validation list.
There are three columns Catagory, Product and Pack size.
How I would like it to work is 1st select a catagory from a validation list,
then in the product column validation list will give a list of all the
products in that catagory, then in the pack size column the pack size list
will appear in the validation list.

This works well until I want to clear the list. If I don't work backward by
selecting the pack size and choosing blank then the product then the catagory.


I have used the following formulas to try and get the lists in the
corresponding row to show blank in the cell when I select the blank in the
Catagory validation list.

Product

=IF(ISBLANK(A$2),"",CHOOSE(MATCH($A2,Catagories,0) ,Spirits,Liqueurs,Aperitiefs___Digestifs,Wines____ Champ,Boxed_Wines,Bottle_Beers,D_Beers,Minerals,Su ndries,""))

Pack size

=IF(ISBLANK($A2),"",IF(VLOOKUP($A2,Cata01,2,FALSE) ="Volume",Volume,IF(VLOOKUP($A2,Cata01,2,FALSE)="M ass",Mass,"")))

Minerals, volumes etc are range names.

If you can help please do so, and if you can suggest a better function for
the existing formulas and or method please do so.

Thank you and best regards

Max