Data validation and Named Range

R

rob nobel

I was under the impression that you could have Data validation check a list
contained in various columns if that list was a Named range. Is that so.
If it is, I cannot get that to work for me.
Rob
 
D

Debra Dalgleish

Data validation can check a multi-column named range in a custom
validation, but can't create a list from a multi-column named range.
 
R

rob nobel

Hi Debra,
I have this as the named range, entitled "MissCodeList"
=Miss!$D$4:$D$15,Miss!$D$21:$D$24,Miss!$K$4,Miss!$K$6
and have Data validation set to custom with "=MissCodeList" in the formula
box.
On closing the validation dialog, it says, "The formula currently evaluates
to an error. Do you wish to continue? I suspect it's because I'm also
trying to avoid certain cells within the columns that's causing this because
even if I remove Miss!$K$4,Miss!$K$6 from the named range it still won't
work.
???
Rob
 
Top