Functions for Finding Cell References: ADDRESS, OFFSET, INDIRECT
We often need to find cell references to use in our formulas. In this post, we will look at several such functions: ADDRESS, ROW, COLUMN, OFFSET, and INDIRECT. We mention INDEX(MATCH) but cover them in other posts. For simplicity, in this post, we use the “A1” format of cell references throughout. The other option, the…