=(LOOKUP(9.99999999999999E+307,C5:AG5))-'[Pods etc. Required Backstock.xls]Sheet1'!$K$5:$L$5
FOR SOME REASON...I can get the =LOOKUP(9.99999999999999E+307,C5:AG5) to yield the correct result But
I have tried sum, counta etc and cannot get that result to subtract the value give at '[Pods etc...