Spreadsheet: 801461d1666208460-formula-to-get-unique-ids-from-one-sheet-to-another-formula-to-get-invoice-number-from-rows-containing-total-only
Sheet: 2A

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