I have three columns (A, B, and C) which I would like to format to hold a pick list. I know this to be easily done with Validation, but here’s the twist. I would like the options available in column B to be limited, or filtered to list only those applicable to what was chosen for column A. Likewise, I would like the options available in column C to be limited, or filtered to list only those applicable to what was chosen for column B.

For example, if column A lists “automobile”, then column B could list “car”, “truck”, or “van”, but could not list “house”. If column A lists “buildings”, then column B could list “house”, “skyscraper”, or “mansion”, but could not list “car”.

Does anyone know how to do this in excel?

Thanks for the help.