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知 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知 using and it's not working.

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