=IF('Form 1'!AI17="Yes","DATA")
Above is a formula that i'm using in a spreadsheet called 'Moves Request Form' & works OK.
My problem is that sometimes I will be deleting 'Form 1' from my workbook & generating it at another time.
When I do this the above formula reads =IF(#REF!AI17="Yes","DATA") because 'Form 1' no longer exists.
How can I write the formula so that it retains the 'Form 1' entry even when 'Form 1' dos'nt exist??