| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Would like to double "validation" in a table
I have a set of named ranges that relate to different selections, I need to
be able to make a selection from a value in the range based on validation of adjacent cell. selection(s) Ranges with 2-7 values 1w days1w 2w days2w 3w days3w |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Would like to double "validation" in a table
See http://www.contextures.com/xlDataVal02.html
"Mark Aide" wrote: I have a set of named ranges that relate to different selections, I need to be able to make a selection from a value in the range based on validation of adjacent cell. selection(s) Ranges with 2-7 values 1w days1w 2w days2w 3w days3w |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Would like to double "validation" in a table
I don't really understand your query, but can you use an offset formula containing what your adjacent cell returns... adjacent cell is named adjcell =offset(start of named range,rows up or down,adjcell) (this assumes your data is in columns) -- robert111 ------------------------------------------------------------------------ robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996 View this thread: http://www.excelforum.com/showthread...hreadid=525636 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
| Look up/math text | Excel Worksheet Functions | |||
| Change Data In Pivot Table | New Users to Excel | |||
| Printing same table on reverse side of all pages. | Excel Discussion (Misc queries) | |||
| Pivot Tables, Help? | Excel Discussion (Misc queries) | |||
Linear Mode
