There are several ways to go about this, depending on your needs.
See below for options.
Note: INDIRECT is avolatile functionand can cause performance problems in more complicated worksheets.
But INDEX can also be used by itself to retrieve values at known coordinates.
If row or column numbers change, the INDEX function returns a new result.
Instead, INDEX is combined with theMATCH function, which calculates the required row and column positions.
For example, =ADDRESS(1,1) returns $A$1.
INDIRECT Function
The Excel INDIRECT function returns a valid cell reference from a given text string.
INDIRECT is useful when you want to assemble a text value that can be used as a valid reference.
you could use INDEX to retrieve individual values, or entire rows and columns.
