Data validation and Named Range

  • Thread starter Thread starter rob nobel
  • Start date Start date
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
 
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Can't located named range 3
How To Use Range Names In Data Validation Criteria (Not For Lists) 1
Data Validation with dynamic ranges 2
Filesize: embedded data validation lists all stored independently? 2
Data validation list using filtered range 3
2007 data validation not working 1
Several data ranges in data validation 3

Back
Top