Hi all,

Probably a simple solution but if I have a repeated formula or link to another workbook in a cell, is there a way to repeat it just using "" or something similar?
Such as:


=IF(ISERROR(LOOKUP(10^99,--MID("|"&''C:\A\[Long_workbook_name.xls]Long_sheetname'!B28,SMALL(IF(((--ISNUMBER(--("0"&MID(SUBSTITUTE(" "&'C:\A\[Long_workbook_name.xls]Long_sheetname'!B28," ","|"),ROW($1:$25),1)))=0)*ISNUMBER(--(MID(SUBSTITUTE(" "&'C:\A\[Long_workbook_name.xls]Long_sheetname'!B28," ","|"),ROW($2:$26),1)))),ROW($2:$26)),2),ROW($1:$25)))),LOOKUP(10^99,--MID("|"&B28,SMALL(IF(((--ISNUMBER(--("0"&MID(SUBSTITUTE(" "&B28," ","|"),ROW($1:$25),1)))=0)*ISNUMBER(--(MID(SUBSTITUTE(" "&B28," ","|"),ROW($2:$26),1)))),ROW($2:$26)),1),ROW($1:$25))),LOOKUP(10^99,--MID("|"&B28,SMALL(IF(((--ISNUMBER(--("0"&MID(SUBSTITUTE(" "&B28," ","|"),ROW($1:$25),1)))=0)*ISNUMBER(--(MID(SUBSTITUTE(" "&B28," ","|"),ROW($2:$26),1)))),ROW($2:$26)),2),ROW($1:$25))))

Where the link is used multiple times, and the same formula used again in the IF statement. Any help would be greatly appreciated.