Help with formulas with multiple conditions

[tshaikh]

Please help, I need to calculate the difference between 2 dates using multiple conditions, see attached, thank you.

[NBVC]

Try:

=IFERROR(IF(B4=$F$1,D4-INDEX($D$4:$D$392,MATCH(1,INDEX(($B$4:$B$392=$F$2)*($A$4:$A$392=A4)*($E$4:$E$392=E4),0),0)),""),"")

copied down.

If you don't want the 0 results to show, then format the range as Custom with Type: 0;-0;;@