View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BugOnPoint BugOnPoint is offline
external usenet poster
 
Posts: 3
Default 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