ExcelBanter - Data Validation

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Data Validation (https://www.excelbanter.com/excel-worksheet-functions/165214-data-validation.html)

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!!

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!!