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.

en English
en Englishes Spanish