I have set up data validation where I have a main list and a dependant List.

Whilst I can get the dependant List to work using INDIRECT what I really
need is that if one option is chosen from the main list eg Ongoing, then I am
able to choose from the Dependant List, but if any other option (other than
Ongoing) is chosen I do not want to be able to select from the dependant list
in this column. eg I want that cell to remain blank.

In the next column I want to be able to choose from the dependant list only
if I select anything BUT Ongoing from the main list and if I choose Ongoing
from the main list I want the cells in this column to remain blank.

I hope this makes some sense - ???

I have tried incorporating the IF function in my data validation but I do
not seem to be able to get it right.
--
Anne