Spreadsheet: 127903d1320678024-vlookups-with-multiple-choices-excel-help-sample-data
Sheet: Sheet1

 | Customers |  |  | Products |  |  | Suppliers |  |  |  | Customer codes
Entity | UK | GMBH | SING | UK | GMBH | SING | UK | GMBH | SING |  | UK |  | GMBH |  | SING
UK | Acryate Research & Development Ltd | 3M Belgium N.V./S.A. | Acrilab S.A. | 3FC-1040CHMW-200 | ACR-282-98-.2K | ACR-282-99.5-1PK | Acryate Research & Development | Acryate Research & Development | Acryate Research & Development |  | Acryate Research & Development Ltd | ACR201 | 3M Belgium N.V./S.A. | 3MB001 | Acrilab S.A. | ACR201
GMBH | Advanced Healthcare Limited | 3M ESPE AG | [NAME], [NAME] | 3FC-1040CHMW-25K | ACR-282-99.5-1PK | ACR-PEA1762-1K | Arkema France | Ametech SRL | Adeka Asia PTE. Ltd |  | Advanced Healthcare Limited | ADV202 | 3M ESPE AG | 3ME202 | Amtrade International Pty Ltd | AMT001
SING | Associated Dental Products Ltd | Aacure Adhesives GmbH | Amtrade International Pty Ltd | [NAME] | ACR-BLB01-0.1PK | ACR-PEMA-1K | Banners | Arizona Chemical Oy | Arkema |  | Associated Dental Products Ltd | ASS001 | Aacure Adhesives GmbH | AAC301 | Antler General Industries (Pvt) Ltd | ANT301
 | Bausch & Lomb | Acheson Industries (Europe) Ltd | Antler General Industries (Pvt) Ltd | 3FC-1050CMMW-200 | ACR-PEA-0.2K | ADE-EH-4360S-15K | BASF SE | Arizona Chemical SA | [NAME] |  | Bausch & Lomb | BAU001 | Acheson Industries (Europe) Ltd | ACH801 | Aquilus Lens International Pte Ltd | AQU201
 | Bausch & Lomb Inc | ACTEGA Rhenania GmbH | Aquilus Lens International Pte Ltd | 3FC-1050CMMW-25K | ACR-PEMA-0.1K | ADE-EP-4901E-200 | Beijing RBL Chemicals Co Ltd | Arizona Chemical | BASF |  | Bausch & Lomb Inc | BAU002 | ACTEGA Rhenania GmbH | ACT112 | [NAME] | AUR201
 | Biomer Technology Ltd | ACTIOL GmbH | [NAME] | 3FC-1050CMMW-IBC | ACR-SIHY-843-1PK | ADE-EP-4901E-20K | BTC Speciality Chemical Distribution Ltd | Arizona Chemical BV. | BTC Speciality Chemical Distribut |  | Biomer Technology Ltd | BIO201 | ACTIOL GmbH | ACT201 | BASF | BAS201
 | Cantor & Nissel Ltd | Adley-Certis b.v. | BASF | 3FC-1055CHMW-200 | ARP-EV-2805-25K | ADE-SP170-1K | Central Glass Co Ltd | Arkema France | Central Glass Co Ltd |  | Cantor & Nissel Ltd | CAN201 | Adley-Certis b.v. | [NAME] | Bausch and [NAME] | BAU201
 | Carbon Chemicals Group Limited | [NAME] | Bausch and [NAME] | 3FC-1055CHMW-25K | ARP-EV-28420-25K | ARR-TFEMA-20K | Central Glass Germany | Arizona Chemical AB | [NAME] ( |  | Carbon Chemicals Group Limited | CAR201 | [NAME] | AGF112 | Bescon | BES201
 | Citifluor Ltd | Agfa-Gevaert N.V. | Bescon | 3FC-1055CHMW-IBC | ARP-EV-28800-25K | [NAME] | Cornelius Chemical Company Ltd | Atlantic Polymer & Chemicals Gm | Cognis Performance Chemicals U |  | Citifluor Ltd | CIT201 | Agfa-Gevaert N.V. | AGF111 | Chaks Cosmetic Design & Servic | CHA301
 | Cognis | Alberdingk Boley GmbH | Chaks Cosmetic Design & Servic | 3FC-1060CHMW-200 | ARP-EV-33400-25K | [NAME] | Cornelius Specialties Limited | BASF SE | Cornelius Specialties Limited |  | Cognis | COG201 | Alberdingk Boley GmbH | ALB801 | Clearlab SG Pte Ltd | CLE201
 | Contamac Limited | Alfa Aesar GmbH & Co KG | Clearlab SG Pte Ltd | 3FC-1060CHMW-25K | AZC-SF2-BULK | [NAME] | Daicolor Italy | Carolus Magnus Centrum | Croda Europe Limited |  | Contamac Limited | CON204 | Alfa Aesar GmbH & Co KG | ALF111 | Dong Won Corporation | DON201
 | Coopervision Manufacturing Ltd | [NAME] | Dong Won Corporation | 3FC-1060CHMW-IBC | AZC-SF2-RP-190K | [NAME] |  |  |  |  | Coopervision Manufacturing Ltd | COO202 | [NAME] | ALZ111 | Dreamcon | DRE201
 | Cornelius Specialties Limited | Ametech SRL | Dreamcon | 3FC-1075CHMW-200 | AZC-SFAT-RPK-185 | [NAME] |  |  |  |  | Cornelius Specialties Limited | COR202 | Ametech SRL | AME111 | Fotopolymer Pte Ltd | HER301
 | CV Manufacturing and Supply UK Ltd | Andreas Jennow A/S | Fotopolymer Pte Ltd | 3FC-1075CHMW-25K | AZC-SFAT-RPK-IBC | [NAME] |  |  |  |  | CV Manufacturing and Supply UK Ltd | CVM001 | Andreas Jennow A/S | AND111 | Gelflex Laboratories | GEL201
 | Daysoft Limited | ANNO Chemicals NV | Gelflex Laboratories | 3FC-1075CHMW-IBC | AZC-SG-RE2085-25 | BAS-VMA-200K |  |  |  |  | Daysoft Limited | DAY202 | ANNO Chemicals NV | ANN001 | Globus Global Supply | PRO001
 | DePuy (Ireland) Limited | [NAME] S.A.U. | Globus Global Supply | 3FC-745AHHM-25K | AZC-SG-RE85K-22K | BTC-SBK6710-0.25 |  |  |  |  | DePuy (Ireland) Limited | DEP001 | [NAME] S.A.U. | [NAME] | Grechem Materials Technologies | GRE301
 | Esschem Europe Ltd | Arkema France | Grechem Materials Technologies | 3FC-745AHHM-500K | AZC-SL-100F-25K | CEN-HFIPM-20K |  |  |  |  | Esschem Europe Ltd | ESS201 | Arkema France | CRA004 | Henkel (Malaysia) Sdn. Bhd. | HEN101
 | Fisher Scientific UK Ltd | Arkema France | Henkel (Malaysia) Sdn. Bhd. | 3FC-745AHHM-750K | AZC-SL-100S-25K | COR-3MPMS-2.4K |  |  |  |  | Fisher Scientific UK Ltd | FIS201 | Arkema France | CRA804 | Honour Enterprise Limited | HON201
 | Gelflex Laboratories | Atlantic Polymers & Chemicals GmbH | Honour Enterprise Limited | 3FC-770AHHM-25K | AZC-SL-100S-500K | COR-APTMS-1K |  |  |  |  | Gelflex Laboratories | BEN202 | Atlantic Polymers & Chemicals GmbH | ATL101 | Hoya Corporation Eye Care Solution | HOY201
 | Honour Enterprise Limited | Avery Dennison Materials Europe GmbH | Hoya Corporation Eye Care Solution | [NAME] | AZC-SL-104S-1000 | COR-BHBPDMS38-1K