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 […]

How to use the INDEX function

Gets a value in a specific cell range based on a row and column number.

  • Weekly Blog EMAIL

    Get a FREE PDF book!

  • Welcome! I am Oscar and here to help you out.

    Feel free to comment and ask Excel questions.

    Make sure you subscribe to my newsletter so you don't miss new blog articles.