Question

How Do You Reference A Parameter Indirectly?

Answer 1

The ADDRESS function uses row and column numbers to create a string address. For example, the formula =ADDRESS(5,6) returns the string $F$5, since $F$5 is the 5th row of column 6. You can use then pass this to INDIRECT to get the value in cell F5. For example, =INDIRECT(ADDRESS(5,6)) .