this should give you what you want:
http://www.contextures.com/xlDataVal01.html

Regards,
Ryan---

--
RyGuy


"Steve" wrote:

Hi all. Can I base a data validation on a table? For example, my
table looks like this:

Lookup Value Named Range
1 NamedRange1
2 NamedRange2
3 NamedRange3

In my data sheet, I have a column of numbers (1-9). I also have
NamedRanges set up.

I guess its sort of a lookup formula of sorts...if row1 ColB has the
value of 1, I would like a data validation in column Z, row1 to be a
list with NamedRange1.

Possible? Thanks!!