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 |
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 |