Forum Discussion
Solved
Using the values from one cell to identify cells in a matrix
This might be hard to explain... I want to use excel to identify a matrix based on a variable from a different cell. As an example, i have two cells, C11 and C12, that might have values 3 and 9 i...
Try
=INDEX(A:A,C11):INDEX(1:1,C12)
or
=OFFSET($A$1,C11-1,0,C12-C11+1,1)
or
=INDIRECT("A"&C11&":A"&C12)