Data Validation problem

E

EdMac

Can anyone help me on this one?

I have set my data validation (List) using a conditional statement a
follows
=IF(AND(C3<>"",D3="",E3=""),OK,N_A) where OK and N_A are named ranges.

The problem I have is that the user can enter any value without gettin
an error message. Why is this and, more importantly, can it be made t
restrict the values to the ones that appear in the drop down lists.

Using Excel 2003 and XP Pro


TIA

E
 
B

Bob Phillips

Uncheck the Ignore Blank checkbox.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top