It was indeed an old named range. I should have known really as there are multiple named ranges in the sheet, I just hadn't expect Excel to react like that mid-formula. The named range was just that single cell, I guess in the past it was used as a note, all very odd.
I agree Alastair, using the...