How can I copy down an indirect formula? When I copy it the lookup reference doesn't change.
My formula is:
=IF(INDIRECT("Q1")="",INDIRECT("R1"),INDIRECT("Q1"))
but when I copy down the cell reference stays the same (I need to keep the indirect formula because I'm adding columns in column Q but it needs to reference column Q even when columns are added). From reading through some other posts I believe I need to add a ROW() or COLUMN() formula in there somewhere.
Anyone run into this before? Any ideas?
Bookmarks