How do I pull a cell reference into a formula?
In the attached, I'm returning the cell reference into cell D4.
I have a formula in C10 that I want to drop this reference into. It needs to dynamically drop into the section at the end that I've highlighted.
=IF(A10<(TODAY()),"",IFERROR(IF(A10<(TODAY()),"",IF(A9>(TODAY()),C9,(FORECAST.ETS(A9,$B$9:B10,$A$9:A10)))),""))
What syntax do I need for that?
Bookmarks