Spreadsheet: 801525d1666246377-formula-to-get-unique-ids-from-one-sheet-to-another-formula-to-get-invoice-number-from-rows-containing-total-only-ans2
Sheet: 2A Extract

[NAME] of supplier | A | B | Invoice number |  | Expected
 |  |  |  |  | 29AARFP1170B1Z9 |  |  | BCRS22/149
 |  |  |  |  | 29AARFP1170B1Z9 |  |  | BCRS22/185
 |  |  |  |  | 29AARFP1170B1Z9 |  |  | BCRS22/193
 |  |  |  |  | 29AARFP1170B1Z9 |  |  | JCRS22/142
 |  |  |  |  | 29AARFP1170B1Z9 |  |  | JCRS22/192
 |  |  |  |  | 29AARFP1170B1Z9 |  |  | JCRS22/210
 |  |  |  |  | 29BBSPM7598F1ZN |  |  | SS/22-23/268
 |  |  |  |  | 29BBSPM7598F1ZN |  |  | SS/22-23/397
 |  |  |  |  | 29AAHPO0472F1ZO |  |  | DI/0021
 |  |  |  |  | 29AAHPO0472F1ZO |  |  | DI/0057
 |  |  |  |  | 29ABGPJ5785Q1ZN |  |  | 22-23/LB-16
 |  |  |  |  | 29ABGPJ5785Q1ZN |  |  | 22-23/LB-18
 |  |  |  |  | 29AEMPN1520N1Z4 |  |  | 59
 |  |  |  |  | 29AGPPJ6033K1ZX |  |  | KY-018/22-23
 |  |  |  |  | 27AKOPM4265H1ZR |  |  | 66/22-23
 |  |  |  |  | 29AAICP9462E1ZZ |  |  | 665/22-23
 |  |  |  |  | 29AAICP9462E1ZZ |  |  | 666/22-23
 |  |  |  |  | 29AAICP9462E1ZZ |  |  | 667/22-23
 |  |  |  |  | 29AAICP9462E1ZZ |  |  | 668/22-23
 |  |  |  |  | 29AAICP9462E1ZZ |  |  | 669/22-23
 |  |  |  |  | 29AAICP9462E1ZZ |  |  | 670/22-23
 |  |  |  |  | 29AAICP9462E1ZZ |  |  | 671/22-23
 |  |  |  |  | 29AAICP9462E1ZZ |  |  | 674/22-23
 |  |  |  |  | 29AAICP9462E1ZZ |  |  | 675/22-23
 |  |  |  |  | 29AAICP9462E1ZZ |  |  | 676/22-23
 |  |  |  |  | 29AAICP9462E1ZZ |  |  | 677/22-23
 |  |  |  |  | 29AHEPA9497N2ZI |  |  | 110
 |  |  |  |  | 29DSLPP9138N1ZL |  |  | AD-55
 |  |  |  |  | 29DSLPP9138N1ZL |  |  | AD-56
 |  |  |  |  | 27AUNPS2381P1ZO |  |  | 367/22-23
 |  |  |  |  | 29AOAPK2814A1ZI |  |  | DSL/20200775
 |  |  |  |  | 29AOAPK2814A1ZI |  |  | DSL/20200776
 |  |  |  |  | 29AMOPC5328H1ZV |  |  | SMCRS22217
 |  |  |  |  | 29AMOPC5328H1ZV |  |  | SWCRS22143
 |  |  |  |  | 29AMOPC5328H1ZV |  |  | SWCRS22147
 |  |  |  |  | 29AMOPC5328H1ZV |  |  | SWCRS22210
 |  |  |  |  | 29AAHFO6175H1ZT |  |  | OS/22-23/14R
 |  |  |  |  | 29AAHFO6175H1ZT |  |  | OS/22-23/15R
 |  |  |  |  | 29AAHFO6175H1ZT |  |  | OS/22-23/201R
 |  |  |  |  | 29AAJFL4517C1ZE |  |  | LLB030/22-23
 |  |  |  |  | 29AHPPK2485B1Z5 |  |  | AMTCS22/017
 |  |  |  |  | 29AHPPK2485B1Z5 |  |  | AMTCS22/039
 |  |  |  |  | 29AHPPK2485B1Z5 |  |  | AMTCS22/043
 |  |  |  |  | 29AHPPK2485B1Z5 |  |  | AMTCS22/065
 |  |  |  |  | 29AHPPK2485B1Z5 |  |  | AMTCS22/066
 |  |  |  |  | 29AHPPK2485B1Z5 |  |  | AMTCS22/078
 |  |  |  |  | 29AHPPK2485B1Z5 |  |  | AMTCS22/094
 |  |  |  |  | 29AHPPK2485B1Z5 |  |  | CUS-22/5022
 |  |  |  |  | 29AHPPK2485B1Z5 |  |  | EN22/003
 |  |  |  |  | 29AHPPK2485B1Z5 |  |  | EN22/004
 |  |  |  |  | 29AHPPK2485B1Z5 |  |  | EN22/021
 |  |  |  |  | 29AHPPK2485B1Z5 |  |  | EN22/026
 |  |  |  |  | 29AIPPM7542Q1Z5 |  |  | 525
 |  |  |  |  | 29AAECS3602B2ZR |  |  | DCR15222301741
 |  |  |  |  | 29AAECS3602B2ZR |  |  | [NAME]
 |  |  |  |  | 29ABWPL2954K1ZS |  |  | 201102946
 |  |  |  |  | 29ABWPL2954K1ZS |  |  | 201102947
 |  |  |  |  | 29ABWPL2954K1ZS |  |  | 201102948
 |  |  |  |  | 29ABWPL2954K1ZS |  |  | 201102949
 |  |  |  |  | 29ABWPL2954K1ZS |  |  | 201102950
 |  |  |  |  | 29AFNPB6658K1ZU |  |  | 22-23/GO-27
 |  |  |  |  | 29AFNPB6658K1ZU |  |  | 22-23/GO-32
 |  |  |  |  | 33ABOPT2854L1Z2 |  |  | 22-23/71
 |  |  |  |  | 27AAQFN0210P1Z0 |  |  | 2633
 |  |  |  |  | 27AAACJ8702F1ZQ |  |  | JG1358/2223
 |  |  |  |  | 27AAACJ8702F1ZQ |  |  | SCE813/2223
 |  |  |  |  | 27AAACJ8702F1ZQ |  |  | SLE231/2223
 |  |  |  |  | 27AAACJ8702F1ZQ |  |  | SLE315/2223
 |  |  |  |  | 29BYQPK7151R1ZA |  |  | 2107
 |  |  |  |  | 29AAUFM1800E1ZA |  |  | MM013
 |  |  |  |  | 29AAUFM1800E1ZA |  |  | MM016
 |  |  |  |  | 29AADHD9537L1ZR |  |  | 6573
 |  |  |  |  | 29ACOPJ5606R1ZR |  |  | 1287
 |  |  |  |  | 27BEYPK0133B1ZO |  |  | 1844
 |  |  |  |  | 29AACCF1132H2ZX |  |  | PHP2223-14581193
 |  |  |  |  | 29AARHM1210K1Z0 |  |  | 10R