Help with formulas with multiple conditions
- Thread starter tshaikh
- Start date
- Joined
- May 20, 2011
- Messages
- 1,518
- Reaction score
- 1
- Points
- 0
- Location
- Mississauga, Canada
- Excel Version(s)
- Excel 2016
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;;@
=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;;@