|Just an FYI...|
Instead of manually changing the first value after 'ADDRESS(' in every cell, here is a trick I often use:
Using your example of the INDIRECT formula being in C4, and the first value after ADDRESS needing to be 4, use:
As you drag this down, ROW() will evaluate to 4, 5, 6, etc.
As another example, if you need the formula to start in Row 1, but still need a 4 after ADDRESS, use:
The ROW() and COLUMN() functions, used either by themselves or with an "offset" will often allow you to autofill formulae throughout a range.