Is it possible to reference a cell within a formula based off the value on another cell in Excel

Andrew Feenan 0
Viewed 20

I have been searching for an answer to this but maybe I'm searching for the wrong thing. I would like to reference a cell based on the product of two cells.

For example

=A1:A(D2*E2)

so if D2=2 and E2=5 the formula would return =A1:A10

Is doing something like this possible?

formula excel
1 Answers

You can use:

=A1:INDEX(A:A,D2*E2)

which is at least only semi-volatile, unlike INDIRECT().

uservF9f0
Related