Thanks Sandy, I was hoping for the usual magic I get in this forum.

Cheers
Jim
In Perth, the not so ancient capital of Western Australia!


"Sandy Mann" wrote:

Your validation works the way you want it for me in XL97.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Jim" wrote in message
...
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?