Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |