=(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. Required Backstock.xls]Sheet1'!$K$5:$L$5
right now it should be 1 - 1 give me a 0 but I just get a value error.
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. Required Backstock.xls]Sheet1'!$K$5:$L$5
right now it should be 1 - 1 give me a 0 but I just get a value error.