On 5 Oct, 23:46, "Max" wrote:
.. why this formula shows #Value in the cell
=IF('[2008.xlsb]Play-Off'!$I$3:$I$4="", ...

It doesn't work with ranges, eg: '[2008.xlsb]Play-Off'!$I$3:$I$4
it has to look something like this: =IF('[2008.xlsb]Play-Off'!$I$3="", ...

--
Max
Singaporehttp://savefile.com/projects/236895
Downloads:18,600 Files:362 Subscribers:60
xdemechanik
--- *

Ah,

You gave me the clue - it's a merged cell that it is referencing and
not actually a range

Thanks Max