Could you please be more specific.

I assume you are trying to have data validation as follow:
- The data-entry cells value must be found in the range Data
So far, no problem, nothing different than normal. You would use a regular
List type of data validation.
- The issue is that Data is made of 3 non-continuous ranges: Data1, Data2,
and Data3
In this case, you could use a function that checks is the value is in one
(at least) of these 3 ranges. To use a function, you would the Custom type of
data validation instead of the List type:

Assuming the data entry cell is A1
=NOT(AND(ISERROR(MATCH(B2,data1,0)),ISERROR(MATCH( B2,data2,0)),ISERROR(MATCH(B2,data3,0))))

would that work for you?
--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"Imaginator" wrote:

I really need an answer if you can provide one

"sebastienm" wrote:

Hi,
What do you mean by 'validate a list'?
--
Regards,
Sébastien
<http://www.ondemandanalysis.com