#N/A

[Guest]

Hou do I get this formula to retrun 0 withou using ISERROR
=+INDEX(Fixed inputs 2'!$I$5:$N$23,MATCH(B15,Fixed imputs
2'!$A$5:$A$23,0),MATCH(H15,Fixed inputs 2'!$I$4:$N$4,0))*I15

If there is no value in B15 it returns #N/A, which is correct, but then all
my other sum formulas bassed on this and other sells also returns #N/A
Thank you

 

[Bob Phillips]

=IF(B15="",0,INDEX(Fixed inputs 2'!$I$5:$N$23,MATCH(B15,Fixed imputs
2'!$A$5:$A$23,0),MATCH(H15,Fixed inputs 2'!$I$4:$N$4,0))*I15)

The + is not needed in Excel, Lotus throwback.

 

[Aladin Akyurek]

Hou do I get this formula to retrun 0 withou using ISERROR
=+INDEX(Fixed inputs 2'!$I$5:$N$23,MATCH(B15,Fixed imputs
2'!$A$5:$A$23,0),MATCH(H15,Fixed inputs 2'!$I$4:$N$4,0))*I15

If there is no value in B15 it returns #N/A, which is correct, but then all
my other sum formulas bassed on this and other sells also returns #N/A
Thank you

=IF((B15="")+(H15=""),LOOKUP(9.99999999999999E+307,CHOOSE({1,2},0,INDEX(Fixed
inputs 2'!$I$5:$N$23,MATCH(B15,Fixed imputs
2'!$A$5:$A$23,0),MATCH(H15,Fixed inputs 2'!$I$4:$N$4,0))*I15)),0)

 

[Aladin Akyurek]

Replace the (B15="")+(H15="") bit with (B15="")*(H15="")

=IF((B15="")+(H15=""),LOOKUP(9.99999999999999E+307,CHOOSE({1,2},0,INDEX(Fixed
inputs 2'!$I$5:$N$23,MATCH(B15,Fixed imputs
2'!$A$5:$A$23,0),MATCH(H15,Fixed inputs 2'!$I$4:$N$4,0))*I15)),0)

--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.