Spreadsheet: 167241d1341932947-update-if-statement-or-another-solution-see-attachment-bom_testing
Sheet: Sheet2

 |  | RECTY | MATNR BOM | MATNR MARC |  | Similarity | IDNRK | MATNR MARC | POSNR | Similarity | Desired result
 |  | H | 9L-8144-K000-01 | 9L-8140-K000-01 |  | 0.9559748427672956 |  |  |  |  | Delete
 |  | H | 9L-8144-K000-02 | 9L-8140-K000-02 |  | 0.9580838323353293 |  |  |  |  | Delete
 |  | D | 9L-8144-K000-02 |  |  |  | 9L-50HN0016 | 9L-50HN0016 | 10 | 1 | Delete
 |  | H | 9L-8144-L000 | 9L-8144-L000 |  | 1
 |  | D | 9L-8144-L000 |  |  |  | 9L-8144-L000-01 | 9L-8144-L000-01 | 10 | 1
 |  | D | 9L-8144-L000 |  |  |  | 9L-8144-L000-02 | 9L-8144-L000-02 | 20 | 1
 |  | D | 9L-8144-L000 |  |  |  | 9L-20PW2011 | 9L-20PW2011 | 30 | 1
 |  | D | 9L-8144-L000 |  |  |  | 9L-40GL0075 | 9L-40GL0075 | 40 | 1
 |  | D | 9L-8144-L000 |  |  |  | 9L-40GL0077 | 9L-40GL0077 | 50 | 1
 |  | H | 9L-8144-L000-01 | 9L-8144-L000-01 |  | 1 |  |  |  |  | Delete
 |  | D | 9L-8144-L000-01 |  |  |  | 9L-8144-L001 | 9L-8144-L001 | 10 | 1 | Delete
 |  | D | 9L-8144-L000-01 |  |  |  | 9L-8144-L002 | 9L-8144-L002 | 20 | 1 | Delete
 |  | D | 9L-8144-L000-01 |  |  |  | 9L-8144-L003 | 9L-8144-L003 | 30 | 1 | Delete
 |  | D | 9L-8144-L000-01 |  |  |  | 9L-8144-M000-01 | 9L-8140-M000-01 | 40 | 0.9559748427672956 | Delete
 |  | D | 9L-8144-L000-01 |  |  |  | 9L-8144-K000-01 | 9L-8140-K000-01 | 50 | 0.9559748427672956 | Delete
 |  | H | 9L-8144-L000-02 | 9L-8144-L000-02 |  | 1 |  |  |  |  | Delete
 |  | D | 9L-8144-L000-02 |  |  |  | 9L-8144-L004 | 9L-8144-L004 | 10 | 1 | Delete
 |  | D | 9L-8144-L000-02 |  |  |  | 9L-8144-L005 | 9L-8144-L005 | 20 | 1 | Delete
 |  | D | 9L-8144-L000-02 |  |  |  | 9L-8144-M000-02 | 9L-8140-M000-02 | 30 | 0.9580838323353293 | Delete
 |  | D | 9L-8144-L000-02 |  |  |  | 9L-8144-K000-02 | 9L-8140-K000-02 | 40 | 0.9580838323353293 | Delete
 |  | H | 9L-8144-L001 | 9L-8144-L001 |  | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-04AC1003 | 9L-04AC1003 | 10 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-23ST1002 | 9L-23ST1002 | 20 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-23AC1004 | 9L-23AC1004 | 30 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-23AC1005 | 9L-23AC1005 | 40 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-09IC1030 | 9L-09IC1030 | 50 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-09AC1029 | 9L-09AC1029 | 60 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-09UV0393 | 9L-09UV0393 | 70 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-08CT0081 | 9L-08CT0081 | 80 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-05ST0010 | 9L-05ST0010 | 90 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-08PT0036 | 9L-08PT0036 | 100 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-01TD0232 | 9L-01TD0232 | 110 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-06CR0002 | 9L-06CR0002 | 120 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-07CR0004 | 9L-07CR0004 | 130 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-07CR0041 | 9L-07CR0041 | 140 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-07CR0044 | 9L-07CR0044 | 150 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-16LE0038 | 9L-16LE0038 | 160 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-16LE0039 | 9L-16LE0039 | 170 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-16LE0035 | 9L-16LE0035 | 180 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-16LE0034 | 9L-16LE0034 | 190 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-17CR0025 | 9L-17CR0025 | 200 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-18CR0027 | 9L-18CR0027 | 210 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-73SH0001 | 9L-73SH0001 | 220 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-25TM0003 | 9L-25TM0003 | 230 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-05CR0039 | 9L-05CR0039 | 240 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-05CR0037 | 9L-05CR0037 | 250 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-05CR0034 | 9L-05CR0034 | 260 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-06CR1001 | 9L-06CR1001 | 270 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-23CN2004 | 9L-23CN2004 | 280 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-07CR0235 | 9L-07CR0235 | 290 | 1
 |  | D | 9L-8144-L001 |  |  |  | [NAME] | [NAME] | 300 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-05AC0027 | 9L-05AC0027 | 310 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-05AC0031 | 9L-05AC0031 | 320 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-05AC0057 | 9L-05AC0057 | 330 | 1
 |  | D | 9L-8144-L001 |  |  |  | 9L-11CT1000 | 9L-11CT1000 | 340 | 1