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="",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.

--
HTH

Bob Phillips

"Esrei" wrote in message
...
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

Esrei wrote:
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)

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

Aladin Akyurek wrote:
Esrei wrote:

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)

--

[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.