Dynamic Range Within INDEX

[BugOnPoint]

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

 

[T. Valko]

Try something like this:

A1 = value1
B1 = value2

=INDEX(INDEX(C:C,A1):INDEX(L:L,B1),A3,B3)

 

[BugOnPoint]

I can see how that would work, thanks. I also dig a bit deeper and figured
out the use of OFFSET within Index - so now I have two ways to do it - cool!

Try something like this:

A1 = value1
B1 = value2

=INDEX(INDEX(C:C,A1):INDEX(L:L,B1),A3,B3)

--
Biff
Microsoft Excel MVP

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

 

[T. Valko]

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP

I can see how that would work, thanks. I also dig a bit deeper and figured
out the use of OFFSET within Index - so now I have two ways to do it -
cool!

Try something like this:

A1 = value1
B1 = value2

=INDEX(INDEX(C:C,A1):INDEX(L:L,B1),A3,B3)

--
Biff
Microsoft Excel MVP

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