LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 26
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
workbook referencing problem Chris J. Excel Worksheet Functions 1 April 3rd 08 08:07 AM
Referencing other workbook. [email protected] Excel Worksheet Functions 1 September 4th 06 05:59 PM
Referencing a different Workbook Ken Excel Worksheet Functions 8 November 24th 05 01:20 AM
Referencing another Workbook Bill Martin -- (Remove NOSPAM from address) Excel Discussion (Misc queries) 0 April 6th 05 07:16 PM
formula referencing another workbook Steve D Excel Worksheet Functions 2 January 7th 05 09:43 PM


All times are GMT +1. The time now is 08:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"