Thread: #N/A
View Single Post
  #1   Report Post  
Esrei
 
Posts: n/a
Default #N/A

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