| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dynamic Range Within INDEX
I would like to set up the use if the INDEX fcn so that elements of the range
can be set based on the values in specified cells. Sort of like this: =INDEX($C[value1]:$L[value2],A3,B3) where value1 and value2 are the numeric value of specified cells, say C1 and D1. I suspect the use of OFFSET is involved, but I can't quite figure out the syntax. Any suggestions appreciated. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Index() or Vlookup() | Excel Worksheet Functions | |||
| Dynamic Range Using INDEX instead of Offset | Excel Discussion (Misc queries) | |||
| dynamic table_array in lookup,match & index | Excel Worksheet Functions | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| dynamic, double vlookup, match, index, dget?? different workbooks | Excel Worksheet Functions | |||
Threaded Mode
