Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation
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!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Data Validation Update Validation Selection | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |