Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 --- |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
workbook referencing problem | Excel Worksheet Functions | |||
Referencing other workbook. | Excel Worksheet Functions | |||
Referencing a different Workbook | Excel Worksheet Functions | |||
Referencing another Workbook | Excel Discussion (Misc queries) | |||
formula referencing another workbook | Excel Worksheet Functions |