If then Data Validation

[Mschelle6]

I have 4 companies and each company has different product numbers. Two of the companies have a sub-collection and the different sub-collections names have the product number. I set up 3 data validation so you can (1) choose the company, (2) choose the collection (when applicable), and then (3)choose the product numbers. I'm using an If/Then statement in the data validation for the "collection category". The formula I’m using is working; however, I want the "Collection Cell" to remain blank if you didn't choose the company with the collection. Below is the formula I’m using and it's not working.

=If(C2="LarsonJuhl_Collections","Collection List'!$C$2:$C$13$,"")

[FDibbins]

Hi, welcome to the forum

If you have already made a selection from a DD, that selection will stay there until you select something else or unselect it, there is no formula that will change that.

Think of Data validation as just another way yo enter data into a cell, it really is no different. All it does is restrict what you can put in a cell, and help with typos etc, and just as you can either have data OR a formulas in any cell, the same if true for a cell with DV. The only way around that, is to use VBA

[Mschelle6]

Thanks, I Just figured out a way to work around this. In my column C3 - I removed the data validation and entered in an IF statement. Then, I entered the data validation formula in the same column and it worked!!!!