Hi All,

I have been searching for a while on how to do the below on various websites, but no luck, any help would be greatly appreciated:

I currently have 3 columns (lets say A, B & C) with dependent dropdown lists (Using the "=indirect(A1)" formula in data validation) for a sort of 3 stage data entry form.

Columns A & B only require entries as dropdown lists but column C requires entries to be a mixture of lists or free format text options depending on what was chosen in column B.

There are hundreds of options for column C, with the majority of them requiring lists so I would prefer not to untick the "Show error alert after invalid data is entered" option as the error alert is useful to ensure no extra text is added to the dropdown list options.

Is it possible to vary the error alert option in column C depending on the option chosen in B? or are there any other ways this could work???

Many thanks in advance.....
JLD