Drop Down List to default to empty

[operationsboy1990]

I have 3 drop down lists. The first cell is the product, second cell is the make and third cell is the model. Cell 2 is dependent on cell 1 and cell 3 is dependent on cell 2

However, when I delete the first cell I want the remaining two to reset back to empty. The only way that is possible according to my research is to use a Macro code. Is there anything else I can do besides that?

Cell 1:=OFFSET(Lists!B1,1,0,COUNTA(Lists!B:B)-1,1)
Cell 2:=OFFSET(Lists!$D$1,MATCH(B9,Lists!$D:$D,0)-1,1,COUNTIF(Lists!$D:$D,B9),1)
Cell 3:=OFFSET(Lists!$G$1,MATCH(C9,Lists!$G:$G,0)-1,1,COUNTIF(Lists!$G:$G,C9),1)

Can I add anything to the Data Validation formula to make what I want happen? Or is Macro the only possible way

 

[bobsan42]

Try with an IF statement for Cells 2 &3:

=IF(ISBLANK([COLOR=#0000ff][I]CELL1[/I][/COLOR]),"",OFFSET(..........))

If the cell will still contain a formula which evaluates to zero length string:

=IF([COLOR=#0000ff][I]CELL1[/I][/COLOR]=""[COLOR=#0000ff][/COLOR],"",OFFSET(..........))

 

[operationsboy1990]

I tried that. Nothing happened. It ended up actually stopped the drop down from working