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!

"T. Valko" wrote:

Try something like this:

A1 = value1
B1 = value2

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

--
Biff
Microsoft Excel MVP


"BugOnPoint" wrote in message
...
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