Forum Discussion

cl1234's avatar
cl1234
Copper Contributor
Aug 28, 2021
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...
  • SergeiBaklan's avatar
    Aug 28, 2021

    cl1234 

    That could be

    =INDEX(A:A,C11):INDEX(A:A,C12)

Resources