confused on Definitions

  • I am just trying to understand some definitions. When would you use Offset or Index instead of using specific cell references? From the Microsoft definitions:
    INDEX(array,row_num,column_num) returns the value of a specified cell or array of cells within array.

    INDEX(reference,row_num,column_num,area_num) returns a reference to specified cells within reference.

    Returns a reference to a range that is a specified number of rows and columns from a cell or range of cells. The reference that is returned can be a single cell or a range of cells. You can specify the number of rows and the number of columns to be returned.

    Thanks in advance for your help!

  • Re: confused on Definitions

    Well, the phrase "how long is a piece of string" springs to mind :) The uses of both functions are many & varied....

    Nevertheless, I have attached a small example of one use of both formulas you ask about.... a search of the board using the words INDEX and/or OFFSET will give you a thousand others no doubt... :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!