Would like to double "validation" in a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
I don't really understand your query, but can you use an offset formul
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need SUMIF / SUMPRODUCT help I think 2
Combine Vlookup and Hlookup 1
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Equation Selector 7
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Filesize: embedded data validation lists all stored independently? 2
SUMIF, use List as a Range 2
Excel Target.column for Data Validation would like to target some cells within column 1

Back
Top