#### gtd526

##### Well-known Member

- Joined
- Jul 30, 2013

- Messages
- 660

- Office Version
- 2019

- Platform
- Windows

Using the index,match formula (D:D), when it returns 0, it's not indicating Less Than 377(C1). How can I get it to indicate Less Than, if true?

Thank you.

NBA.xlsm | |||||||
---|---|---|---|---|---|---|---|

A | B | C | D | E | |||

1 | 538 | 377 | 161 | ||||

2 | 12/12 | Ind % | Avg | ||||

3 | Team | H:H | Inj's | Pts | TEST | ||

4 | MIL | 5 | 170 | TRUE | |||

5 | NYK | 1 | 226 | TRUE | |||

6 | BKN | 4 | 350 | TRUE | |||

7 | DET | 3 | 304 | TRUE | |||

8 | DAL | 3 | 538 | FALSE | |||

9 | OKC | 0 | 0 | FALSE | |||

10 | NO | 3 | 0 | FALSE | |||

11 | SAN | 2 | 345 | TRUE | |||

12 | MIN | 1 | 399 | FALSE | |||

13 | POR | 4 | 327 | TRUE | |||

14 | ORL | 5 | 258 | TRUE | |||

15 | LAL | 4 | 495 | FALSE | |||

Test |

Cell Formulas | ||
---|---|---|

Range | Formula | |

B1 | B1 | =Injuries!A5 |

C1 | C1 | =B1*0.7 |

D1 | D1 | =B1*0.3 |

A2 | A2 | =TODAY() |

B4:B15 | B4 | =IF($H4="","",ROUND(SUMIFS($AT$7:$BN$142,$AP$5:$BJ$140,$H4),2)) |

C4:C15 | C4 | =IFERROR(INDEX(Injuries!$2:$2,MATCH($A$4:$A$33,Injuries!$1:$1,0)),"") |

D4:D15 | D4 | =IFERROR(INDEX(Injuries!$B$16:$EQ$16,MATCH($A4,Injuries!$B$1:$EQ$1,0)+4),"") |

E4:E15 | E4 | =D4<$C$1 |