I have a cell (D11) validated to a list named Jnl that has two choices , Job
& Ledger.

When Ledger is selected in D11, cell E11 validates to a list of several
codes named LedgerList. When Job is selected from the validation list D11,
cell F11 shows a list of only two codes from a list named CAT.

I use the formula =IF(D11="Ledger",LedgerList," ") as the validation for E11
and =IF(D11="Job",CAT,"") for F11. The validation will not display "" ,or
blank, when the Acc Type is changed. The last selected code remains.

Is there a better way to have E11 display a blank (empty) when the Acc Type
is changed to Job in D11 and allow the selection of the CAT list in F11 and
visa-versa?