Referencing another file/workbook
 

Hi

Can anyone tell me why this formula shows #Value in the cell

=IF('[2008.xlsb]Play-Off'!$I$3:$I$4="","Winner",IF('[2008.xlsb]Play-
Off'!$J$3:$J$4'[2008.xlsb]Play-Off'!$J$5:$J$6,'[2008.xlsb]Play-Off'!$G
$4,'[2008.xlsb]Play-Off'!$G$6))

I have both workbooks/files open and when building the formula, click
across to '2008' to pick the cells I want to reference.

The 'Evaluate Formula' tool indicates it is the first IF statement at
fault.
If I do this across sheets of the same workbook it works OK

Thanks
Neil

Referencing another file/workbook
 

.. 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
Singapore
http://savefile.com/projects/236895
Downloads:18,600 Files:362 Subscribers:60
xdemechanik
---

Referencing another file/workbook
 

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

Referencing another file/workbook
 

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

well, I think those are ranges that's captured in your posted formula. but
glad it got you going. anyway, the general refrain is to avoid using merged
cells
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:18,600 Files:362 Subscribers:60
xdemechanik
---

Referencing another file/workbook
 

On 6 Oct, 00:25, "Max" wrote:
You gave me the clue - it's a merged cell that it is referencing
and not actually a range

well, I think those are ranges that's captured in your posted formula. but
glad it got you going. anyway, the general refrain is to avoid using merged
cells
--
Max
Singaporehttp://savefile.com/projects/236895
Downloads:18,600 Files:362 Subscribers:60
xdemechanik
--- *

Yes, well clicking on the merged cell captured it as a range. Now I've
taken that out, all is well

Cheers