From addresses to values

A really important use of the cell addresses you made using ADDRESS() is to get the value stored at that location. To do this, you use the INDIRECT() function. (The name of the function comes from the computer science concept of indirection, where you pass the address of a variable in memory to a function rather than the variable itself.)

If the cell J42 contains the value 99, then typing =ADDRESS(42, 10) in cell J43 will give that cell a value of $J$42. Now the formula =INDIRECT("J43") will return the value 99.

Here the dataset includes the addresses you created in the previous exercise.