Using the INDIRECT Function in Array Formulas

The INDIRECT function creates a reference specified by a text string. In the example just referred to, the formula 

you ll want to use a variable number of terms in your array formula. You can do this by using INDIRECT. In the following example we want to evaluate N, where cell A1 contains the value for N. In this example let s assume that cell A1 contains 20. We use the formula 

The text argument of the indirect worksheet function evaluates to 1 20 , and the expression ROW(INDIRECT( 1 A1)) evaluates to 

---