Hello
I have a formula in a cell (say C3) that looks at a sheet called "Forward" and extracts the value from a cell within it.
ie.
=Forward!A1
However, the sheet 'Forward' does not always exist and I need to prevent this formula from returning the "#REF!" statement. Is there any way of modifying the formula so that it returns a zero when sheet 'Forward' does not exist?
Many thank to anyone that can figure it out.
Cheers
Johno