Hey there gentlemen, I've written a formula that it seems to be working "kinda" fine. The only problem is that I'm getting a "FALSE" statement instead of a "0" in return. Could someone please tell me what I'm doing wrong? Thanks,
{=IF(ISERROR(IF(P7="MAINTENANCE","0",IF(B$22="YES",INDEX($C$48:$C$62,MATCH(K7&L7,$A$48:$A$62&$B$48:$B$62,0),IF(B$22="NO","0","0"))))),"-",IF(P7="MAINTENANCE",0,IF(B$22="YES",INDEX($C$48:$C$62,MATCH(K7&L7,$A$48:$A$62&$B$48:$B$62,0),IF(B$22="NO","0","0")))))}
Zenarte
Bookmarks