Spreadsheet: 699481d1602616963-need-help-with-the-error-in-excel-index-match-formula-whats-wrong-with-the-formula
Sheet: Sheet1

Plant - Material | Plant - Substitute Material | Stock Available to Plan | Stock Consumed | Stock Balanced | Material Requirement | Order Fulfilled | Substitute Part Stock
1010-00544-H6074-77 | 1010-648MF | 32 | 1 | 31 | 0 | YES
1010-0544H-50610-54 | 1010-697RMF | 15 | 1 | 14 | 0 | YES
1010-0544H-50610-54 | 1010-697RMF | 14 | 2 | 12 | 0 | YES
1010-0544H-50610-54 | 1010-697RMF | 12 | 2 | 10 | 0 | YES
1010-1131MFCTB | 1010-1131MF | 0 | 0 | 0 | 3 | NO
1010-1131MF-FRT | 1010-VL31X | 144 | 24 | 120 | 0 | YES
1010-1131MF-FRT | 1010-VL31X | 120 | 26 | 94 | 0 | YES
1010-1131MF-FRT | 1010-VL31X | 94 | 36 | 58 | 0 | YES
1010-1131PMFCT1 | 1010-1131PMF | 0 | 0 | 0 | 2 | NO
1010-11U1LCT1 | 1010-11U1L | 164 | 2 | 162 | 0 | YES
1010-11U1RCT1 | 1010-11U1R | 0 | 0 | 0 | 1 | NO
1010-11U1RCT1 | 1010-11U1R | 0 | 0 | 0 | 1 | NO
1010-11U1RCT1 | 1010-11U1R | 0 | 0 | 0 | 1 | NO
1010-11U1RCT1 | 1010-11U1R | 0 | 0 | 0 | 3 | NO
1010-1231MF | 1010-1231MF | 72 | 3 | 69 | 0 | YES
1010-1231MF | 1010-1231MF | 69 | 2 | 67 | 0 | YES
1010-1231PMF | 1010-1231PMF | 72 | 1 | 71 | 0 | YES
1010-12N12A-4A-1FP | 1010-12N12A-4A-1FP | 0 | 0 | 0 | 7 | NO
1010-12N12A-4A-1FP | 1010-12N12A-4A-1FP | 0 | 0 | 0 | 5 | NO
1010-12N14-3AFP | 1010-12N14-3AFP | 0 | 0 | 0 | 3 | NO
1010-12N7-4AFP | 1010-12N7-4AFP | 0 | 0 | 0 | 2 | NO
1010-12V-10SE | 1010-12V-10SE | 5 | 2 | 3 | 0 | YES
1010-12V-10SE | 1010-12V-10SE | 3 | 1 | 2 | 0 | YES
1010-12V-12 | 1010-12v-12 | 86 | 4 | 82 | 0 | YES
1010-12V-2.3V | 1010-12v-2.3V | 120 | 6 | 114 | 0 | YES
1010-12V-2.3V | 1010-12v-2.3V | 114 | 8 | 106 | 0 | YES
1010-12V-2.3V | 1010-12v-2.3V | 106 | 30 | 76 | 0 | YES
1010-12V-2.3V | 1010-12v-2.3V | 76 | 10 | 66 | 0 | YES
1010-12V-3.4 | 1010-12V-3.4 | 37 | 1 | 36 | 0 | YES
1010-12V-4.5 | 1010-12V-4.5 | 162 | 3 | 159 | 0 | YES
1010-12V-4.5 | 1010-12V-4.5 | 159 | 3 | 156 | 0 | YES
1010-12V-4.5 | 1010-12V-4.5 | 156 | 2 | 154 | 0 | YES
1010-12V-4.5 | 1010-12V-4.5 | 154 | 7 | 147 | 0 | YES
1010-12V-4CTC | 1010-12V-4 | 2 | 1 | 1 | 0 | YES
1010-12V-5-03 | 1010-12V-5-03 | 140 | 113 | 27 | 0 | YES
1010-12V-7 | 1010-12V-7 | 134 | 2 | 132 | 0 | YES
1010-12V-7 | 1010-12V-7 | 132 | 3 | 129 | 0 | YES
1010-24FLT | 1010-634MF | 0 | 0 | 0 | 6 | NO
1010-24M-7CT1 | 1010-24M-7 | 13 | 1 | 12 | 0 | YES
1010-5140RMF | 1010-5140RMF | 0 | 0 | 0 | 1 | NO
1010-5140RMF | 1010-5140RMF | 0 | 0 | 0 | 2 | NO
1010-5140RMF | 1010-5140RMF | 0 | 0 | 0 | 4 | NO
1010-5140RMF | 1010-5140RMF | 0 | 0 | 0 | 4 | NO
1010-5140RMF | 1010-5140RMF | 0 | 0 | 0 | 4 | NO
1010-5140RMF | 1010-5140RMF | 0 | 0 | 0 | 2 | NO
1010-5140RMF | 1010-5140RMF | 0 | 0 | 0 | 2 | NO
1010-5140RMF | 1010-5140RMF | 0 | 0 | 0 | 1 | NO
1010-5140RMF | 1010-5140RMF | 0 | 0 | 0 | 1 | NO
1010-5140RMF | 1010-5140RMF | 0 | 0 | 0 | 2 | NO
1010-5140RMF | 1010-5140RMF | 0 | 0 | 0 | 1 | NO
1010-5140RMF | 1010-5140RMF | 0 | 0 | 0 | 2 | NO
1010-5140RMF | 1010-5140RMF | 0 | 0 | 0 | 1 | NO
1010-5140RMF | 1010-5140RMF | 0 | 0 | 0 | 5 | NO
1010-5151RXMFCTC | 1010-5151RXMF | 0 | 0 | 0 | 2 | NO
1010-5151RXMFCTC | 1010-5151RXMF | 0 | 0 | 0 | 2 | NO
1010-5151RXMFCTC | 1010-5151RXMF | 0 | 0 | 0 | 4 | NO
1010-5151RXMFCTC | 1010-5151RXMF | 0 | 0 | 0 | 2 | NO
1010-5151RXMFCTC | 1010-5151RXMF | 0 | 0 | 0 | 2 | NO
1010-5151RXMFCTC | 1010-5151RXMF | 0 | 0 | 0 | 4 | NO
1010-5151RXMFCTC | 1010-5151RXMF | 0 | 0 | 0 | 2 | NO
1010-5151RXMFCTC | 1010-5151RXMF | 0 | 0 | 0 | 5 | NO
1010-5151RXMFCTC | 1010-5151RXMF | 0 | 0 | 0 | 4 | NO
1010-5151RXMFCTC | 1010-5151RXMF | 0 | 0 | 0 | 4 | NO
1010-5151RXMFCTC | 1010-5151RXMF | 0 | 0 | 0 | 4 | NO
1010-5151RXMFCTC | 1010-5151RXMF | 0 | 0 | 0 | 4 | NO
1010-5151RXMFCTC | 1010-5151RXMF | 0 | 0 | 0 | 4 | NO
1010-5151RXMFCTC | 1010-5151RXMF | 0 | 0 | 0 | 1 | NO
1010-524MF | 1010-524MF | 9 | 2 | 7 | 0 | YES
1010-525MF | 1010-525MF | 0 | 0 | 0 | 2 | NO
1010-525MF | 1010-525MF | 0 | 0 | 0 | 1 | NO
1010-525MF | 1010-525MF | 0 | 0 | 0 | 5 | NO
1010-525MF | 1010-525MF | 0 | 0 | 0 | 1 | NO
1010-525MF | 1010-525MF | 0 | 0 | 0 | 6 | NO
1010-525MF | 1010-525MF | 0 | 0 | 0 | 5 | NO
1010-525MF | 1010-525MF | 0 | 0 | 0 | 2 | NO
1010-525MF | 1010-525MF | 0 | 0 | 0 | 1 | NO
1010-525MF | 1010-525MF | 0 | 0 | 0 | 5 | NO
1010-525MF | 1010-525MF | 0 | 0 | 0 | 5 | NO
1010-525MF | 1010-525MF | 0 | 0 | 0 | 5 | NO
1010-525MF | 1010-525MF | 0 | 0 | 0 | 10 | NO
1010-525MF | 1010-525MF | 0 | 0 | 0 | 10 | NO
1010-525MFCT1 | 1010-525MF | 139 | 1 | 138 | 0 | YES
1010-525MFCT1 | 1010-525MF | 138 | 2 | 136 | 0 | YES
1010-525MFCT1 | 1010-525MF | 136 | 4 | 132 | 0 | YES
1010-525MFCT1 | 1010-525MF | 132 | 4 | 128 | 0 | YES
1010-525MFCT1 | 1010-525MF | 128 | 3 | 125 | 0 | YES
1010-525MFCT1 | 1010-525MF | 125 | 2 | 123 | 0 | YES
1010-525MFCT1 | 1010-525MF | 123 | 3 | 120 | 0 | YES
1010-525MFCT1 | 1010-525MF | 120 | 2 | 118 | 0 | YES
1010-525MFCT1 | 1010-525MF | 118 | 5 | 113 | 0 | YES
1010-525MFCT1 | 1010-525MF | 113 | 2 | 111 | 0 | YES
1010-525MFCT1 | 1010-525MF | 111 | 4 | 107 | 0 | YES
1010-525MFCT1 | 1010-525MF | 107 | 2 | 105 | 0 | YES
1010-525MFCT1 | 1010-525MF | 105 | 3 | 102 | 0 | YES
1010-525MFCT1 | 1010-525MF | 102 | 1 | 101 | 0 | YES
1010-526MFCT1 | 1010-526MF | 114 | 1 | 113 | 0 | YES
1010-526MFCT1 | 1010-526MF | 113 | 3 | 110 | 0 | YES
1010-526MFCT1 | 1010-526MF | 110 | 6 | 104 | 0 | YES
1010-526MFCT1 | 1010-526MF | 104 | 4 | 100 | 0 | YES