Spreadsheet: 775520d1649163000-find-a-cell-value-in-a-table-based-on-three-or-more-criteria-without-using-sumifs-index-match-test
Sheet: Sheet1

DAY | Date | Request # | File # | Resources | Process | Documetation | Non Critical Score | [NAME] | Fulfillment | Notifications | Critical Score | Billing Score | 50pts | NUM MONTH | MONTH | Agent
60 | 44621 | 1701940 | 8052645 | 5 | 5 | 5 | 15 | 10 | NA | 0 | 10 | 5 | 30 | 03. MAR | MAR | BARBARA HANRAHAN
61 | 44622 | 1702798 | 8095341 | 5 | NA | 5 | 10 | 10 | 0 | 10 | 20 | 5 | 35 | 03. MAR | MAR | BARBARA HANRAHAN
62 | 44623 | 1703524 | 8128196 | 5 | 5 | NA | 10 | 10 | 10 | 10 | 30 | NA | 40 | 03. MAR | MAR | BARBARA HANRAHAN
63 | 44624 | 1704003 | 8071425 | 5 | 5 | 5 | 15 | NA | 10 | 10 | 20 | 5 | 40 | 03. MAR | MAR | BARBARA HANRAHAN
66 | 44627 | 1704520 | 8126908 | 5 | 0 | 5 | 10 | 10 | 10 | 10 | 30 | NA | 40 | 03. MAR | MAR | BARBARA HANRAHAN
67 | 44628 | 1705171 | 8022211 | NA | 0 | 5 | 5 | 10 | 10 | 10 | 30 | 5 | 40 | 03. MAR | MAR | BARBARA HANRAHAN
68 | 44629 | 1706177 | 8217874 | 5 | NA | 5 | 10 | 10 | NA | 10 | 20 | 5 | 35 | 03. MAR | MAR | BARBARA HANRAHAN
69 | 44630 | 1707123 | 8169617 | 5 | 5 | NA | 10 | NA | 10 | 10 | 20 | NA | 30 | 03. MAR | MAR | BARBARA HANRAHAN
70 | 44631 | 1707172 | 8205331 | 5 | 5 | 5 | 15 | 10 | 10 | 10 | 30 | 5 | 50 | 03. MAR | MAR | BARBARA HANRAHAN
73 | 44634 | 1708582 | 8079203 | 5 | NA | 5 | 10 | 10 | 10 | 10 | 30 | 5 | 45 | 03. MAR | MAR | BARBARA HANRAHAN
74 | 44635 | 1709418 | 8214547 | 5 | 5 | NA | 10 | NA | NA | 10 | 10 | 5 | 25 | 03. MAR | MAR | BARBARA HANRAHAN
75 | 44636 | 1709681 | 8128263 | 5 | 5 | 5 | 15 | 0 | 10 | 10 | 20 | NA | 35 | 03. MAR | MAR | BARBARA HANRAHAN
76 | 44637 | 1709697 | 8143915 | 0 | NA | 0 | NA | 10 | 10 | 10 | 30 | 5 | 35 | 03. MAR | MAR | BARBARA HANRAHAN
77 | 44638 | 1711040 | 8048848 | NA | 5 | 5 | 10 | 10 | 10 | 10 | 30 | 5 | 45 | 03. MAR | MAR | BARBARA HANRAHAN
80 | 44641 | 1711985 | 8145295 | 5 | 5 | 5 | 15 | NA | 10 | 10 | 20 | 5 | 40 | 03. MAR | MAR | BARBARA HANRAHAN
81 | 44642 | 1712476 | 8151712 | 5 | NA | NA | 5 | 10 | NA | 10 | 20 | NA | 25 | 03. MAR | MAR | BARBARA HANRAHAN
82 | 44643 | 1713038 | 8116219 | NA | 5 | 5 | 10 | 10 | 10 | 10 | 30 | 5 | 45 | 03. MAR | MAR | BARBARA HANRAHAN
83 | 44644 | 1714202 | 7993992 | 5 | 5 | 5 | 15 | 10 | 10 | 10 | 30 | 5 | 50 | 03. MAR | MAR | BARBARA HANRAHAN
84 | 44645 | 1714805 | 8136936 | NA | 5 | NA | 5 | NA | 10 | 10 | 20 | 5 | 30 | 03. MAR | MAR | BARBARA HANRAHAN
87 | 44648 | 1715245 | 8074537 | 5 | 5 | 5 | 15 | 10 | 10 | 0 | 20 | NA | 35 | 03. MAR | MAR | BARBARA HANRAHAN
88 | 44649 | 1716159 | 8105516 | 5 | NA | 5 | 10 | 10 | NA | 10 | 20 | 5 | 35 | 03. MAR | MAR | BARBARA HANRAHAN
89 | 44650 | 1716622 | 8229243 | 5 | 5 | NA | 10 | 10 | 10 | 10 | 30 | 5 | 45 | 03. MAR | MAR | BARBARA HANRAHAN
90 | 44651 | 1717080 | 8212515 | 5 | 5 | 5 | 15 | 10 | 10 | 10 | 30 | NA | 45 | 03. MAR | MAR | BARBARA HANRAHAN
 |  |  |  |  |  |  | THIS IS WHAT I'M GETTING. I use SUMIFS and get "0". |  |  |  |  | THIS IS WHAT I'M TRYING TO GET. What do I use to get "NA"?
 |  |  |  |  | NAME |  | DAY | Non Critical Score | Critical Score | Billing Score |  | DAY | Non Critical Score | Critical Score | Billing Score
 |  |  |  |  | BARBARA HANRAHAN |  | 66 |  |  |  |  | 66 |  |  | NA
 |  |  |  |  |  |  | 67 |  |  |  |  | 67
 |  |  |  |  |  |  | 68 |  |  |  |  | 68
 |  |  |  |  |  |  | 69 |  |  |  |  | 69 |  |  | NA
 |  |  |  |  |  |  | 76 |  |  |  |  | 76 | NA
 |  |  |  |  |  |  | SUM: |  |  |  |  | SUM:
 |  |  |  |  |  |  | AVERAGE: |  |  |  |  | AVERAGE: