Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link Workbooks
I have a master workbook that links to several other workbooks. In the master
workbook, my formula is set up to reference a cell. If I type the number "1" in the reference cell ($C$4) and the link does not find the linked workbook (,(IF(ISERROR('G:\Orlcorr\FY 06\WOR\P03 Week5\[Jackson.xls]ROLLUP'!$M$77)=TRUE,0,), the intent was to leave a blank in the formula cell (e.g "-"). I have pasted my formula below. The ("if(iserror") part of the formula is not working. Any thoughts on how I may correct or change the formula? =IF($C$4=1,(IF(ISERROR('G:\Orlcorr\FY 06\WOR\P03 Week5\[Jackson.xls]ROLLUP'!$M$77)=TRUE,0,('G:\Orlcorr\FY 06\WOR\P03 Week5\[Jackson.xls]ROLLUP'!$M$77))),VLOOKUP(3,'G:\Orlcorr\FY 06\Flash\[Region 1.xls]Jackson'!$A$10:$CG$95,$A$107+5,FALSE)) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link Workbooks
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I merge and link workbooks into one summary workbook? | Excel Worksheet Functions | |||
Can you link many workbooks to one template? And Update? | Excel Discussion (Misc queries) | |||
How workbooks link to other workbooks | Excel Discussion (Misc queries) | |||
Variable Link to Workbooks | Excel Worksheet Functions | |||
How to Link named ranges from multiple Workbooks into a single Wo. | Excel Discussion (Misc queries) |