Would like to double "validation" in a table

[Mark Aide]

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

[bpeltzer]

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

[robert111]

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)