Create Powerful Numbers Spreadsheets With the INDIRECT Function

The INDIRECT function allows you to look up the value of a cell based on a cell reference. So you can take stings like C2 and find the value of the cell C2. This allows you to construct cells references from other values to create powerful lookups that refer to cells in other tables or even sheets.

Comments: One Response to “Create Powerful Numbers Spreadsheets With the INDIRECT Function”

    Frank
    5 years ago

    I have used the indirect function a number of times in the past and agree that it is a very useful function. Despite my experience, as always, I find that Gary adds extra information and ideas I had not previously thought to do.

Comments Closed.