Search code examples
excelformula

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

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?

Solution

  • You can use:

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

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