INDEX function
Excel » Functions » Lookup and reference » INDEX function »
Rearrange cells in a cell range to vertically distributed values
The formula in cell B8 uses a named range to calculate the row and column needed to extract the correct […]
Gets a value in a specific cell range based on a row and column number.