inserting drop down list option for the entire workbook with Mold Name as unique identifier

Anthonymu

New Member
Joined
May 3, 2019
Messages
1
MOLD NAMEDATE RECEIVEDDRAWING NO.DESIGN WEIGHTFINISHTYPE
200ML UGANDA WARAGI11/02/20161031-BDS-M-MCVA205+/-10 GRAMS28/38 STEEL CAPDG
200ML UGANDA WARAGI07/03/201710313-BDS-M-MDVA185+/-10 GRAMS28 PPDG
200ML K-VANT24/10/2017MGW 10365230+/-12 GRAMS30 PPDG
200ML GENERIC (GM)24/10/2017MGW 10358175+/-12 GRAMSG-NIPDG
200ML JEBEL SPECIAL16/06/2018MGW 10334210+/-12 GRAMS30 PPDG
200ML LN06/03/2019MGW 10447210+/-12 GRAMSG-NIPDG
200ML FURAHA26/08/2011MGW 10095245+/-12 GRAMS28 PPDG
MOLD NAMEDATE RECEIVEDDRAWING NO.DESIGN WEIGHTFINISHTYPE
205ML GENERIC09/05/2018MGW 10169170+/-12 GRAMS28 PPDG
205ML UBL GM13/04/2015100126-BDS-M-MDVA210+/-12 GRAMS31.5 ROPPDG
205ML GM27/05/2016100126-BDS-M-MDVA210+/-12 GRAMS31.5 ROPPDG
205ML FLYING HORSE (LOGO)20/10/201310161-BDS-M-MCVA170+/-12 GRAMS28 PPDG
205ML FLYING HORSE (PLAIN)15/01/201410161-BDS-M-MCVA170+/-12 GRAMS28PPDG
205ML BISCEPT (BL/GENERIC)17/03/201510210-BDS-M-MDVA210+/-12 GRAMS31.5 ROPPDG
205ML MEGATRADE05/04/201310145-BDS-M-BPVA255+/-12 GRAMS30 PPDG
MOLD NAMEDATE RECEIVEDDRAWING NO.DESIGN WEIGHTFINISHTYPE
250ML ASL LION LOGO 4.25"07/04/2018MGW 10331235+/-15 GRAMSG-NIPDG
250ML ASL LION LOGO ROUND 5"20/12/2018MGW 10412235+/-15 GRAMSG-NIPDG
250ML VAN ROH ROUND19/11/2015MGW 10219255+/-12 GRAMS30 PPDG
250ML LDK GUALA09/01/2017240 GRAMSG-NIPDG
250ML LDK GUALA ROUND02/10/2018MGW 10385230+/-12 GRAMSG-NIPDG
250ML K-VANT02/12/2015MGW 10225255+/-12 GRAMSG-NIPDG
250ML KENYA CANE 4.25"09/05/201810277-BDS-M-MCVA230+/-10 GRAMSG-NIPDG
250ML KENYA CANE 5"07/06/201810277-BDS-M-MCVA230+/-10 GRAMSG-NIPDG
250ML FRM (LOGO)08/11/2018MGW10397250+/-12 GRAMS30 PPDG
250ML FRM ROUND08/11/2018MGW 10409230+/-12 GRAMS30 PPDG
250ML RDL ROUND17/01/2019MGW 10417230+/-12 GRAMSG-NIPDG
250ML RDL FLASK28/01/2019MGW 10437235+/-15 GRAMSG-NIPDG
250ML RDL FLAT27/02/2019MGW 10434235+/-15 GRAMSG-NIPDG
250ML SUNDRY GM17/03/201510143-BDS-M-MDVA235+/-17 GRAMS30PPDG
250ML SUNDRY EABL17/12/2013235+/-17 GRAMS30PPDG
250ML SUNDRY EABL GUALA07/04/201810304-BDS-M-MCVA250+/-10 GRAMSG-NIPDG
250ML EABL GENERIC (CPT MORGAN)19/01/2019MGW 10449215+/-10 GRAMSG-NIPDG
250ML GM BOTTLE08/09/2017MGW 10344220+/-12 GRAMS30 PPDG
250ML GM GUALA27/02/201910249-BDS-M-MCVA220+/-12 GRAMSG-NIPDG
250ML FURAHA26/08/201110095-BDS-M-BVL300+/-15 GRAMS28 PPDG
250ML GRAND BEVERAGE21/07/201310162-BDS-M-MDVA235+/-12 GRAMS30 PPDG
250ML GENERIC13/02/2012MGW 10083230+/-12 GRAMS31.5 ROPPDG
250ML FLYING HORSE01/12/2014MGW 10197235+/-12 GRAMS30 PPDG
250ML BISCEPT13/09/2018MGW 10395235+/-12 GRAMSG-NIPDG
MOLD NAMEDATE RECEIVEDDRAWING NO.DESIGN WEIGHTFINISHTYPE
300ML SNAPP19/10/201110114-BDS-M-MDVA275+/-12 GRAMS26-600DG
330ML BEER10/06/201110101-BDS-M-MDVA265+/-16 GRAMS26-600DG
MOLD NAMEDATE RECEIVEDDRAWING NO.DESIGN WEIGHTFINISHTYPE
350ML DDL OVAL FLASK14/12/2012340+/-17 GRAMS30 PPSG
350ML ASL LION LOGO FLASK06/11/2017MGW 10332340+/-10 GRAMSG-NIPSG
350ML UGANDA WARAGI25/02/201610230-BDS-M-MCVA320+/-12 GRAMS38/48 STEEL CAPDG
350ML KENYA CANE07/06/201610276-BDS-M-MCVA300+/-10 GRAMSG-NIPDG
350ML FRM (LOGO)06/12/2018MGW 10401340+/-15 GRAMS30 PPDG
350ML FRM (PLAIN)06/12/2018MGW 10410320+/- 15 GRAMS30 PPDG
350ML SUNDRY OVAL FLASK26/08/201110104-BSG-M-MCRA340+/-17 GRAMS30 PPSG
MOLD NAMEDATE RECEIVEDDRAWING NO.DESIGN WEIGHTFINISHTYPE
500ML VINEPACK (ADL)11/06/201310154-BDS-M-MCVA450+/-15 GRAMSG-NIPDG
500ML RDL FLAT27/02/2019MGW 10436380+/-15 GRAMSG-NIPSG
MOLD NAMEDATE RECEIVEDDRAWING NO.DESIGN WEIGHTFINISHTYPE
750ML IDV WHISKEY18/05/201610105-BSG-M-MDRA507+/-17 GRAMS30 PPSG
750ML DDL SQUARE BOTTLE15/11/201210127-BSG-M-BPRA570+/-17 GRAMSGUALASG
750ML ASL22/04/201310155-BSG-M-MDRA500+/-15 GRAMS30 PP SG
750ML ASL GUALA10/01/201410193-BDS-M-MCVA500+/-15 GRAMS1031 GUALADG
750ML ASL GUALA ROUND 5''20/12/2018MGW 10439500+/-17 GRAMS1031 GUALADG
750ML VINEPACK ROUND03/05/201310153-BSG-M-FL550+/-17 GRAMS30PPSG
750ML CONTESSA RUM26/07/201310164-BSG-M-MCRA550+/-17 GRAMSGUALASG
750ML VAN ROH ROUND19/11/201510218-BSG-M-MDRA525+/-17 GRAMS30 SCNSBSG
750ML GILBEY GIN20/09/201410192-BSG-M-MDRA525+/- 20 GRAMS30 PPSG
750ML UGANDA WARAGI26/06/2015MGW 10223505 +/-17 GRAMS30 STEEL CAPSG
750ML LDK GUALA27/11/201810227-BDS-M-MDVA500+/-17 GRAMS1031 GUALADG
750ML K-VANT22/12/2015MGW 10226540+/-17 GRAMS1031 GUALASG
750ML KENYA CANE15/06/201610278-BDS-M-MCVA440+/-17 GRAMS1031 GUALADG
750ML FRM ROUND (LOGO)06/12/2018MGW10411500+/-18 GRAMS30 PPSG
750ML FRM ROUND (PLAIN)06/12/2018MGW 10403500+/-18 GRAMS30 PPSG
750ML RDL BOTTLE17/01/2019MGW 10418480+/-18 GRAMS1031/59 GUALADG

<colgroup><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

Forum statistics

Threads
1,213,483
Messages
6,113,919
Members
448,533
Latest member
thietbibeboiwasaco

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top