complex split formula to merge as per description

L

learn99

New Member
Joined
Jul 11, 2017
Messages
10
I have a formula which looks in column K ,L and G to merge pack size description in J ,
However In G only the conversion units are extracted that is L , cl with its corresponding numbers.

However I having trouble when adding L litres corresponding for wines only , I have tried to add 1 litres but unsucessful.

Can anyone assist to correct the formula .





FGHIJKLMXY
BOUTON OR CROUT.AIL&F.HERBE60G
CHABRIOR *******S NATURE 250G
PAQUITO SIROP CITRON.VRT 75CL
AIX LES BAINS EAU MIN 6X1L5
AIX LES BAINS E.MINERALE 6X1L
BROCELIANDE EAU MIN6X1L5 FARD
ONDINE E.DE SOURCE 6X1L5 1/2P
BABV BLC MANGUE E.CLUB
CHABRIOR GENOISE CITRON 150G
should read 12*2*1L in column J
VDP CX PIN ROUGE SYRAH
VDPOC CAB.SAUV RG XPIN 37.5CL
VDP OC MERLOT RGE X PIN BIB5L
VDP CX PIN ROUGE MERLOT 75CL
GAMAY RGE CHARENTAIS 75CL
VDP CX PIN RGE CAB.SAUVIGN75CL
VDP CX DU PIN BLC CHARDONN75CL

<tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=5B9BD5]#5B9BD5[/URL] , align: center"]CODE ARTICLE[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=5B9BD5]#5B9BD5[/URL] , align: center"]DESIGNATION[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=5B9BD5]#5B9BD5[/URL] , align: center"]Tariff No[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=5B9BD5]#5B9BD5[/URL] , align: center"]Description[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=5B9BD5]#5B9BD5[/URL] , align: right"]Pack Size Description[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=5B9BD5]#5B9BD5[/URL] , align: center"]CNDT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=5B9BD5]#5B9BD5[/URL] , align: center"]Qte Cndt[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=5B9BD5]#5B9BD5[/URL] , align: center"]QTE UVC[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]17017154[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]19054090[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]TOASTED BREAD[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]20[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]6[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]120[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"]17082321[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]19059090[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]BISCUITS[/TD]
[TD="align: right"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]12[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]25[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"]300[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="align: right"]17118363[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]21069060[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]SYRUP[/TD]
[TD="align: right"]6*5*75CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="align: right"]17311278[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]22011011[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]MINERAL WATER[/TD]
[TD="align: right"]105*6*1.5L[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"]105[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]
[TD="align: right"]17311280[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]22011011[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]MINERAL WATER[/TD]
[TD="align: right"]39*6*1L[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]
[TD="align: right"]17314311[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]22011011[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]MINERAL WATER[/TD]
[TD="align: right"]104*6*1.5L[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]104[/TD]
[TD="align: right"]104[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]
[TD="align: right"]17314605[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]22011011[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]MINERAL WATER[/TD]
[TD="align: right"]56*6*1.5L[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]56[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]
[TD="align: right"]17330954[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]22041090[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]WINES[/TD]
[TD="align: right"]6*1*75CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]
[TD="align: right"]41027155[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]19053100[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]BISCUITS[/TD]
[TD="align: right"][/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]240[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]52335060[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "]VIN ESPAGNE BLC MOELCALISSOU1L[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]22041090[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "]WINES[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]12*2*75CL[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]12[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]2[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]24[/TD]

[TD="align: right"][/TD]

[TD="align: center"]12[/TD]
[TD="align: right"]52337011[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]22041090[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]WINES[/TD]
[TD="align: right"]6*14*75CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]84[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]13[/TD]
[TD="align: right"]52337025[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]22041090[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]WINES[/TD]
[TD="align: right"]12*5*37.5CL[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]14[/TD]
[TD="align: right"]52337073[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]22041090[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]WINES[/TD]
[TD="align: right"]4*12*75CL[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]48[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]
[TD="align: right"]52337077[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]22041090[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]WINES[/TD]
[TD="align: right"]6*39*75CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]234[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]16[/TD]
[TD="align: right"]52337300[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]22041090[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]WINES[/TD]
[TD="align: right"]12*3*75CL[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]17[/TD]
[TD="align: right"]52337602[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]22041090[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]WINES[/TD]
[TD="align: right"]6*43*75CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]43[/TD]
[TD="align: right"]258[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]18[/TD]
[TD="align: right"]52338041[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]22041090[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]WINES[/TD]
[TD="align: right"]6*5*75CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>
SPLIT SPIRITS (2)​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J2[/TH]
[TD="align: left"]=IF(LEFT(H2)="2",IF(I2="WINES",K2&"*"&L2&"*"&IF(ISNUMBER(FIND(37.5,G2)),"37.5CL","75CL"),IF(U2="*",M2&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G2,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G2))-2),{1,2,3}))&"*",K2&"*"&L2&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G2),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J3[/TH]
[TD="align: left"]=IF(LEFT(H3)="2",IF(I3="WINES",K3&"*"&L3&"*"&IF(ISNUMBER(FIND(37.5,G3)),"37.5CL","75CL"),IF(U3="*",M3&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G3,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G3))-2),{1,2,3}))&"*",K3&"*"&L3&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G3),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J4[/TH]
[TD="align: left"]=IF(LEFT(H4)="2",IF(I4="WINES",K4&"*"&L4&"*"&IF(ISNUMBER(FIND(37.5,G4)),"37.5CL","75CL"),IF(U4="*",M4&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G4,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G4))-2),{1,2,3}))&"*",K4&"*"&L4&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G4),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J5[/TH]
[TD="align: left"]=IF(LEFT(H5)="2",IF(I5="WINES",K5&"*"&L5&"*"&IF(ISNUMBER(FIND(37.5,G5)),"37.5CL","75CL"),IF(U5="*",M5&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G5,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G5))-2),{1,2,3}))&"*",K5&"*"&L5&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G5),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J6[/TH]
[TD="align: left"]=IF(LEFT(H6)="2",IF(I6="WINES",K6&"*"&L6&"*"&IF(ISNUMBER(FIND(37.5,G6)),"37.5CL","75CL"),IF(U6="*",M6&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G6,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G6))-2),{1,2,3}))&"*",K6&"*"&L6&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G6),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J7[/TH]
[TD="align: left"]=IF(LEFT(H7)="2",IF(I7="WINES",K7&"*"&L7&"*"&IF(ISNUMBER(FIND(37.5,G7)),"37.5CL","75CL"),IF(U7="*",M7&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G7,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G7))-2),{1,2,3}))&"*",K7&"*"&L7&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G7),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J8[/TH]
[TD="align: left"]=IF(LEFT(H8)="2",IF(I8="WINES",K8&"*"&L8&"*"&IF(ISNUMBER(FIND(37.5,G8)),"37.5CL","75CL"),IF(U8="*",M8&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G8,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G8))-2),{1,2,3}))&"*",K8&"*"&L8&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G8),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J9[/TH]
[TD="align: left"]=IF(LEFT(H9)="2",IF(I9="WINES",K9&"*"&L9&"*"&IF(ISNUMBER(FIND(37.5,G9)),"37.5CL","75CL"),IF(U9="*",M9&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G9,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G9))-2),{1,2,3}))&"*",K9&"*"&L9&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G9),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J10[/TH]
[TD="align: left"]=IF(LEFT(H10)="2",IF(I10="WINES",K10&"*"&L10&"*"&IF(ISNUMBER(FIND(37.5,G10)),"37.5CL","75CL"),IF(U10="*",M10&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G10,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G10))-2),{1,2,3}))&"*",K10&"*"&L10&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G10),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J11[/TH]
[TD="align: left"]=IF(LEFT(H11)="2",IF(I11="WINES",K11&"*"&L11&"*"&IF(ISNUMBER(FIND(37.5,G11)),"37.5CL","75CL"),IF(U11="*",M11&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G11,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G11))-2),{1,2,3}))&"*",K11&"*"&L11&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G11),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J12[/TH]
[TD="align: left"]=IF(LEFT(H12)="2",IF(I12="WINES",K12&"*"&L12&"*"&IF(ISNUMBER(FIND(37.5,G12)),"37.5CL","75CL"),IF(U12="*",M12&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G12,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G12))-2),{1,2,3}))&"*",K12&"*"&L12&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G12),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J13[/TH]
[TD="align: left"]=IF(LEFT(H13)="2",IF(I13="WINES",K13&"*"&L13&"*"&IF(ISNUMBER(FIND(37.5,G13)),"37.5CL","75CL"),IF(U13="*",M13&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G13,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G13))-2),{1,2,3}))&"*",K13&"*"&L13&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G13),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J14[/TH]
[TD="align: left"]=IF(LEFT(H14)="2",IF(I14="WINES",K14&"*"&L14&"*"&IF(ISNUMBER(FIND(37.5,G14)),"37.5CL","75CL"),IF(U14="*",M14&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G14,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G14))-2),{1,2,3}))&"*",K14&"*"&L14&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G14),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J15[/TH]
[TD="align: left"]=IF(LEFT(H15)="2",IF(I15="WINES",K15&"*"&L15&"*"&IF(ISNUMBER(FIND(37.5,G15)),"37.5CL","75CL"),IF(U15="*",M15&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G15,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G15))-2),{1,2,3}))&"*",K15&"*"&L15&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G15),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J16[/TH]
[TD="align: left"]=IF(LEFT(H16)="2",IF(I16="WINES",K16&"*"&L16&"*"&IF(ISNUMBER(FIND(37.5,G16)),"37.5CL","75CL"),IF(U16="*",M16&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G16,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G16))-2),{1,2,3}))&"*",K16&"*"&L16&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G16),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J17[/TH]
[TD="align: left"]=IF(LEFT(H17)="2",IF(I17="WINES",K17&"*"&L17&"*"&IF(ISNUMBER(FIND(37.5,G17)),"37.5CL","75CL"),IF(U17="*",M17&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G17,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G17))-2),{1,2,3}))&"*",K17&"*"&L17&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G17),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]J18[/TH]
[TD="align: left"]=IF(LEFT(H18)="2",IF(I18="WINES",K18&"*"&L18&"*"&IF(ISNUMBER(FIND(37.5,G18)),"37.5CL","75CL"),IF(U18="*",M18&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G18,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G18))-2),{1,2,3}))&"*",K18&"*"&L18&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G18),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
 
Sort by date Sort by votes
Right Peter sir. The issue is with the cell referencing. @learn99: Please make the necessary changes, and then post your query..

use the following formula in J2 cell:

=IF(LEFT(H2)="2",IF(I2="WINES",K2&"*"&L2&"*"&IF(ISNUMBER(FIND(37.5,G2)),"37.5CL",IF(ISNUMBER(FIND("75CL",G2)),"75CL",IF(ISNUMBER(FIND("1L5",G2)),"1.5L",IF(ISNUMBER(FIND("1L",G2)),"1L","75CL")))),IF(U2="*",M2&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G2,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G2))-2),{1,2,3}))&"*",K2&"*"&L2&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G2),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),"")
 
Upvote 0

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Hi learn99,
As I checked , if the Tariff Number starts from 2008, it stands for Prepared Nuts, Prepared Fruits and Mixed Nuts, which are quantified in grams or Kgs. Hence a new formula was formulated, which you can use in cell J2:

=IF(LEFT(H2,4)<>"2008",IF(LEFT(H2)="2",IF(I2="WINES",K2&"*"&L2&"*"&IF(ISNUMBER(FIND(37.5,G2)),"37.5CL",IF(ISNUMBER(FIND("75CL",G2)),"75CL",IF(ISNUMBER(FIND("1L5",G2)),"1.5L",IF(ISNUMBER(FIND("1L",G2)),"1L","75CL")))),IF(U2="*",M2&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G2,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G2))-2),{1,2,3}))&"*",K2&"*"&L2&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G2),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")


Please try this and let know if there still is any issue encountered...

Also, You will have to manually enter a value * in the U28 column to show the appropriate result.
Still you can clarify any doubts...
 
Upvote 0
Hi Asakhy & Peter

I will tried and checked the issue, the data itself is very complex and will slim it so that it is more easy to understand .

I will revert back
 
Upvote 0
https://drive.google.com/open?id=1pB...-2ZywD8JtQfec1


Hello asakhy & Peter


the formula works well , being on right track, but needs some tuning, I have slim to my best the file with all possible issues encountered


All data in yellow have some issues particularly with those have a g meaning gram which is not required ,
Some show N/A appears which iferror can be used but for litres with n/a , i think the formula needs to be adjusted , attached on drive google a sheettab with issues 2104,2103,2106, 2001,2002,2003,2005 code


vinegar 0.5L appears as 0.5CL, some with litres or cl appears N/A which I think needs an adjustment in the formula .


Could have a look please, very tough


Book1
HIJKLMUVW
1Tariff NoDescriptionPack Size DescriptionCNDTQte CndtQTE UVCexpected resultsChecking
220019090PRESERVED VEGETABLES#N/A1612192
320019090PRESERVED VEGETABLES#N/A61060
420021000PRESERVED TOMATOES#N/A12672
520021000PRESERVED TOMATOES#N/A6848
620031000PRESERVED MUSHROOM16*10*30CL1610160
720056000PRESERVED ASPARAGUS#N/A9763
820081900PREPARED NUTS 2214308TRUE
920089900PREPARED FRUITS 325160TRUE
1020089900MIX FRUIT MELANGE 1815270TRUE
1120091200ORANGE JUICES16*7*1L16711216*7*1LTRUE
1220091200GRAPEFRUIT JUICE16*7*1L16711216*7*1LTRUE
1320098900JUICES6*11*2L611666*11*2LTRUE
1420098900JUICES#N/A611666*11*2.5L#N/A
1520098900JUICES#N/A613786*13*5L#N/A
1620099000MIXED JUICES#N/A16711216*7*3.5L#N/A
1721032000TOMATO SAUCE#N/A8756
1821039090SAUCE PREPARATION#N/A644264#N/A
1921039090SAUCE PREPARATION#N/A6530#N/A
2021041000SOUP PREPARATION18*5*70CL18590FALSE
2121042000HOMOGENISED FOODS#N/A637222#N/A
2221069060SYRUP6*6*1L66366*6*1LTRUE
2321069060SYRUP6*7*1L67426*7*1LTRUE
2421069060SYRUP#N/A67426*7*5L#N/A
2521069060SYRUP6*6*1.5L66366*6*1.5LTRUE
2621069060SYRUP6*7*2L67426*7*75CLFALSE
2721069090TOPPINGS#N/A12560#N/A
2821069090FOOD PREP.#N/A167112#N/A
2921069090FOOD PREP.#N/A619114#N/A
3021069090INFUSIONS6*32*30CL632192FALSE
3122011011MINERAL WATER105*6*1.5L1105105*105*6*1.5LTRUE
3222011011MINERAL WATER39*6*1L13939*39*6*1LTRUE
3322011011MINERAL WATER104*6*1.5L1104104*104*6*1.5LTRUE
3422011011MINERAL WATER56*6*1.5L56156*56*6*1.5LTRUE
3522011011MINERAL WATER28*6*50CL4728*28*6*50CLTRUE
3622011011MINERAL WATER36*6*50CL4936*36*6*50CLTRUE
3722011011MINERAL WATER6*11*1.5L611666*11*1.5LTRUE
3822021091FRUIT JUICE6*13*75CL613786*13*75CLTRUE
3922021091FRUIT JUICE6*10*75CL610606*10*75CLTRUE
4022021091FRUIT JUICE6*13*75CL613786*13*75CLTRUE
4122021091FRUIT JUICE6*35*1L6352106*35*1LTRUE
4222021091FRUIT JUICE6*50*2L6503006*50*2LTRUE
4322021091FRUIT JUICE6*70*2L6704206*70*2LTRUE
4422029970ICE TEA6*30*75CL6301806*30*75CLTRUE
4522029970ICE TEA6*12*2L612726*12*2LTRUE
4622029970ICE TEA6*30*1.5L6301806*30*1.5LTRUE
4722029970ICE TEA6*30*1.5L6301806*30*1.5LTRUE
4822029990BEVERAGES6*69*1L6694146*69*1LTRUE
4922041090WINES12*5*37.5CL1256012*5*37.5CLTRUE
5022041090WINES6*6*75CL66366*6*5LFALSE
5122041090WINES6*5*75CL65306*5*4LFALSE
5222041090WINES6*8*75CL68486*8*75CLTRUE
5322041090WINES6*6*75CL66366*6*5LFALSE
5422041090WINES6*9*1.5L69546*9*1.5LTRUE
5522041090WINES6*9*75CL69546*9*2LFALSE
5622041090WINES6*3*1L63186*3*1LTRUE
5722041090WINES6*2*75CL62126*2*2.5LFALSE
5822041090WINES6*5*75CL65306*5*3LFALSE
5922060039SHANDY134*10*25CL267134*134*10*25CLTRUE
6022087019LIQUEURS6*9*70CL69546*9*75CLFALSE
6122087019LIQUEURS6*32*70CL6321926*32*75CLFALSE
6222087019LIQUEURS6*23*70CL6231386*23*70CLTRUE
6322087019LIQUEURS6*5*70CL65306*5*70CLTRUE
6422087019LIQUEURS6*3*70CL63186*3*70CLTRUE
6522087019LIQUEURS6*5*50CL65306*5*50CLTRUE
6604090000HONEY 813104TRUE
6708021200ALMONDS 61484TRUE
6809012100COFFEE 245120TRUE
6911063000VEG. POWDER 6212TRUE
7019053100BISCUITS 10440TRUE
7119053100BISCUITS 1015150TRUE
7219054090TOASTED BREAD 12560TRUE
7319054090TOASTED BREAD 1226312TRUE
7420079900COMPOTE#N/A1620320#N/A
7520079900COMPOTE#N/A2411264#N/A
7620079900COMPOTE#N/A2425600#N/A
7720079900COMPOTE#N/A2013260#N/A
7820079900JAMS#N/A2424576#N/A
7920079900JAMS24*1*33CL24124FALSE
8020079900JAMS#N/A16348#N/A
8121041000SOUP PREPARATION#N/A1016160#N/A
8221041000SOUP PREPARATION#N/A1016160#N/A
8321041000SOUP PREPARATION10*17*1L1017170FALSE
8421041000SOUP PREPARATION24*11*30CL2411264FALSE
8521041000SOUP PREPARATION24*14*1L2414336FALSE
8621042000HOMOGENISED FOODS#N/A2023460#N/A
8722029910SOJA DRINK15*22*1L152233015*22*1LTRUE
8822087019LIQUEURS12*19*70CL121922812*19*70CLTRUE
8922090090VINEGAR6*11*50CL611666*11*0.5LFALSE
9022090090VINEGAR6*62*75CL6623726*62*75CLTRUE
9122090090VINEGAR6*62*1L6623726*62*1LTRUE
9222090090VINEGAR6*62*1L6623726*62*3LFALSE
9322090090VINEGAR6*62*1L6623726*62*5LFALSE
9422090090VINEGAR6*62*1L6623726*62*1L5FALSE
SPLIT (2)
Cell Formulas
RangeFormula
J2=IF(LEFT(H2,4)<>"2008",IF(LEFT(H2)="2",IF(I2="WINES",K2&"*"&L2&"*"&IF(ISNUMBER(FIND(37.5,G2)),"37.5CL",IF(ISNUMBER(FIND("75CL",G2)),"75CL",IF(ISNUMBER(FIND("1L5",G2)),"1.5L",IF(ISNUMBER(FIND("1L",G2)),"1L","75CL")))),IF(U2="*",M2&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G2,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G2))-2),{1,2,3}))&"*",K2&"*"&L2&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G2),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J3=IF(LEFT(H3,4)<>"2008",IF(LEFT(H3)="2",IF(I3="WINES",K3&"*"&L3&"*"&IF(ISNUMBER(FIND(37.5,G3)),"37.5CL",IF(ISNUMBER(FIND("75CL",G3)),"75CL",IF(ISNUMBER(FIND("1L5",G3)),"1.5L",IF(ISNUMBER(FIND("1L",G3)),"1L","75CL")))),IF(U3="*",M3&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G3,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G3))-2),{1,2,3}))&"*",K3&"*"&L3&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G3),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J4=IF(LEFT(H4,4)<>"2008",IF(LEFT(H4)="2",IF(I4="WINES",K4&"*"&L4&"*"&IF(ISNUMBER(FIND(37.5,G4)),"37.5CL",IF(ISNUMBER(FIND("75CL",G4)),"75CL",IF(ISNUMBER(FIND("1L5",G4)),"1.5L",IF(ISNUMBER(FIND("1L",G4)),"1L","75CL")))),IF(U4="*",M4&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G4,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G4))-2),{1,2,3}))&"*",K4&"*"&L4&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G4),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J5=IF(LEFT(H5,4)<>"2008",IF(LEFT(H5)="2",IF(I5="WINES",K5&"*"&L5&"*"&IF(ISNUMBER(FIND(37.5,G5)),"37.5CL",IF(ISNUMBER(FIND("75CL",G5)),"75CL",IF(ISNUMBER(FIND("1L5",G5)),"1.5L",IF(ISNUMBER(FIND("1L",G5)),"1L","75CL")))),IF(U5="*",M5&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G5,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G5))-2),{1,2,3}))&"*",K5&"*"&L5&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G5),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J6=IF(LEFT(H6,4)<>"2008",IF(LEFT(H6)="2",IF(I6="WINES",K6&"*"&L6&"*"&IF(ISNUMBER(FIND(37.5,G6)),"37.5CL",IF(ISNUMBER(FIND("75CL",G6)),"75CL",IF(ISNUMBER(FIND("1L5",G6)),"1.5L",IF(ISNUMBER(FIND("1L",G6)),"1L","75CL")))),IF(U6="*",M6&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G6,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G6))-2),{1,2,3}))&"*",K6&"*"&L6&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G6),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J7=IF(LEFT(H7,4)<>"2008",IF(LEFT(H7)="2",IF(I7="WINES",K7&"*"&L7&"*"&IF(ISNUMBER(FIND(37.5,G7)),"37.5CL",IF(ISNUMBER(FIND("75CL",G7)),"75CL",IF(ISNUMBER(FIND("1L5",G7)),"1.5L",IF(ISNUMBER(FIND("1L",G7)),"1L","75CL")))),IF(U7="*",M7&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G7,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G7))-2),{1,2,3}))&"*",K7&"*"&L7&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G7),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J8=IF(LEFT(H8,4)<>"2008",IF(LEFT(H8)="2",IF(I8="WINES",K8&"*"&L8&"*"&IF(ISNUMBER(FIND(37.5,G8)),"37.5CL",IF(ISNUMBER(FIND("75CL",G8)),"75CL",IF(ISNUMBER(FIND("1L5",G8)),"1.5L",IF(ISNUMBER(FIND("1L",G8)),"1L","75CL")))),IF(U8="*",M8&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G8,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G8))-2),{1,2,3}))&"*",K8&"*"&L8&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G8),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J9=IF(LEFT(H9,4)<>"2008",IF(LEFT(H9)="2",IF(I9="WINES",K9&"*"&L9&"*"&IF(ISNUMBER(FIND(37.5,G9)),"37.5CL",IF(ISNUMBER(FIND("75CL",G9)),"75CL",IF(ISNUMBER(FIND("1L5",G9)),"1.5L",IF(ISNUMBER(FIND("1L",G9)),"1L","75CL")))),IF(U9="*",M9&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G9,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G9))-2),{1,2,3}))&"*",K9&"*"&L9&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G9),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J10=IF(LEFT(H10,4)<>"2008",IF(LEFT(H10)="2",IF(I10="WINES",K10&"*"&L10&"*"&IF(ISNUMBER(FIND(37.5,G10)),"37.5CL",IF(ISNUMBER(FIND("75CL",G10)),"75CL",IF(ISNUMBER(FIND("1L5",G10)),"1.5L",IF(ISNUMBER(FIND("1L",G10)),"1L","75CL")))),IF(U10="*",M10&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G10,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G10))-2),{1,2,3}))&"*",K10&"*"&L10&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G10),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J11=IF(LEFT(H11,4)<>"2008",IF(LEFT(H11)="2",IF(I11="WINES",K11&"*"&L11&"*"&IF(ISNUMBER(FIND(37.5,G11)),"37.5CL",IF(ISNUMBER(FIND("75CL",G11)),"75CL",IF(ISNUMBER(FIND("1L5",G11)),"1.5L",IF(ISNUMBER(FIND("1L",G11)),"1L","75CL")))),IF(U11="*",M11&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G11,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G11))-2),{1,2,3}))&"*",K11&"*"&L11&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G11),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J12=IF(LEFT(H12,4)<>"2008",IF(LEFT(H12)="2",IF(I12="WINES",K12&"*"&L12&"*"&IF(ISNUMBER(FIND(37.5,G12)),"37.5CL",IF(ISNUMBER(FIND("75CL",G12)),"75CL",IF(ISNUMBER(FIND("1L5",G12)),"1.5L",IF(ISNUMBER(FIND("1L",G12)),"1L","75CL")))),IF(U12="*",M12&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G12,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G12))-2),{1,2,3}))&"*",K12&"*"&L12&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G12),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J13=IF(LEFT(H13,4)<>"2008",IF(LEFT(H13)="2",IF(I13="WINES",K13&"*"&L13&"*"&IF(ISNUMBER(FIND(37.5,G13)),"37.5CL",IF(ISNUMBER(FIND("75CL",G13)),"75CL",IF(ISNUMBER(FIND("1L5",G13)),"1.5L",IF(ISNUMBER(FIND("1L",G13)),"1L","75CL")))),IF(U13="*",M13&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G13,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G13))-2),{1,2,3}))&"*",K13&"*"&L13&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G13),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J14=IF(LEFT(H14,4)<>"2008",IF(LEFT(H14)="2",IF(I14="WINES",K14&"*"&L14&"*"&IF(ISNUMBER(FIND(37.5,G14)),"37.5CL",IF(ISNUMBER(FIND("75CL",G14)),"75CL",IF(ISNUMBER(FIND("1L5",G14)),"1.5L",IF(ISNUMBER(FIND("1L",G14)),"1L","75CL")))),IF(U14="*",M14&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G14,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G14))-2),{1,2,3}))&"*",K14&"*"&L14&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G14),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J15=IF(LEFT(H15,4)<>"2008",IF(LEFT(H15)="2",IF(I15="WINES",K15&"*"&L15&"*"&IF(ISNUMBER(FIND(37.5,G15)),"37.5CL",IF(ISNUMBER(FIND("75CL",G15)),"75CL",IF(ISNUMBER(FIND("1L5",G15)),"1.5L",IF(ISNUMBER(FIND("1L",G15)),"1L","75CL")))),IF(U15="*",M15&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G15,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G15))-2),{1,2,3}))&"*",K15&"*"&L15&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G15),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J16=IF(LEFT(H16,4)<>"2008",IF(LEFT(H16)="2",IF(I16="WINES",K16&"*"&L16&"*"&IF(ISNUMBER(FIND(37.5,G16)),"37.5CL",IF(ISNUMBER(FIND("75CL",G16)),"75CL",IF(ISNUMBER(FIND("1L5",G16)),"1.5L",IF(ISNUMBER(FIND("1L",G16)),"1L","75CL")))),IF(U16="*",M16&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G16,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G16))-2),{1,2,3}))&"*",K16&"*"&L16&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G16),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J17=IF(LEFT(H17,4)<>"2008",IF(LEFT(H17)="2",IF(I17="WINES",K17&"*"&L17&"*"&IF(ISNUMBER(FIND(37.5,G17)),"37.5CL",IF(ISNUMBER(FIND("75CL",G17)),"75CL",IF(ISNUMBER(FIND("1L5",G17)),"1.5L",IF(ISNUMBER(FIND("1L",G17)),"1L","75CL")))),IF(U17="*",M17&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G17,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G17))-2),{1,2,3}))&"*",K17&"*"&L17&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G17),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J18=IF(LEFT(H18,4)<>"2008",IF(LEFT(H18)="2",IF(I18="WINES",K18&"*"&L18&"*"&IF(ISNUMBER(FIND(37.5,G18)),"37.5CL",IF(ISNUMBER(FIND("75CL",G18)),"75CL",IF(ISNUMBER(FIND("1L5",G18)),"1.5L",IF(ISNUMBER(FIND("1L",G18)),"1L","75CL")))),IF(U18="*",M18&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G18,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G18))-2),{1,2,3}))&"*",K18&"*"&L18&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G18),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J19=IF(LEFT(H19,4)<>"2008",IF(LEFT(H19)="2",IF(I19="WINES",K19&"*"&L19&"*"&IF(ISNUMBER(FIND(37.5,G19)),"37.5CL",IF(ISNUMBER(FIND("75CL",G19)),"75CL",IF(ISNUMBER(FIND("1L5",G19)),"1.5L",IF(ISNUMBER(FIND("1L",G19)),"1L","75CL")))),IF(U19="*",M19&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G19,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G19))-2),{1,2,3}))&"*",K19&"*"&L19&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G19),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J20=IF(LEFT(H20,4)<>"2008",IF(LEFT(H20)="2",IF(I20="WINES",K20&"*"&L20&"*"&IF(ISNUMBER(FIND(37.5,G20)),"37.5CL",IF(ISNUMBER(FIND("75CL",G20)),"75CL",IF(ISNUMBER(FIND("1L5",G20)),"1.5L",IF(ISNUMBER(FIND("1L",G20)),"1L","75CL")))),IF(U20="*",M20&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G20,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G20))-2),{1,2,3}))&"*",K20&"*"&L20&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G20),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J21=IF(LEFT(H21,4)<>"2008",IF(LEFT(H21)="2",IF(I21="WINES",K21&"*"&L21&"*"&IF(ISNUMBER(FIND(37.5,G21)),"37.5CL",IF(ISNUMBER(FIND("75CL",G21)),"75CL",IF(ISNUMBER(FIND("1L5",G21)),"1.5L",IF(ISNUMBER(FIND("1L",G21)),"1L","75CL")))),IF(U21="*",M21&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G21,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G21))-2),{1,2,3}))&"*",K21&"*"&L21&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G21),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J22=IF(LEFT(H22,4)<>"2008",IF(LEFT(H22)="2",IF(I22="WINES",K22&"*"&L22&"*"&IF(ISNUMBER(FIND(37.5,G22)),"37.5CL",IF(ISNUMBER(FIND("75CL",G22)),"75CL",IF(ISNUMBER(FIND("1L5",G22)),"1.5L",IF(ISNUMBER(FIND("1L",G22)),"1L","75CL")))),IF(U22="*",M22&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G22,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G22))-2),{1,2,3}))&"*",K22&"*"&L22&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G22),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J23=IF(LEFT(H23,4)<>"2008",IF(LEFT(H23)="2",IF(I23="WINES",K23&"*"&L23&"*"&IF(ISNUMBER(FIND(37.5,G23)),"37.5CL",IF(ISNUMBER(FIND("75CL",G23)),"75CL",IF(ISNUMBER(FIND("1L5",G23)),"1.5L",IF(ISNUMBER(FIND("1L",G23)),"1L","75CL")))),IF(U23="*",M23&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G23,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G23))-2),{1,2,3}))&"*",K23&"*"&L23&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G23),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J24=IF(LEFT(H24,4)<>"2008",IF(LEFT(H24)="2",IF(I24="WINES",K24&"*"&L24&"*"&IF(ISNUMBER(FIND(37.5,G24)),"37.5CL",IF(ISNUMBER(FIND("75CL",G24)),"75CL",IF(ISNUMBER(FIND("1L5",G24)),"1.5L",IF(ISNUMBER(FIND("1L",G24)),"1L","75CL")))),IF(U24="*",M24&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G24,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G24))-2),{1,2,3}))&"*",K24&"*"&L24&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G24),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J25=IF(LEFT(H25,4)<>"2008",IF(LEFT(H25)="2",IF(I25="WINES",K25&"*"&L25&"*"&IF(ISNUMBER(FIND(37.5,G25)),"37.5CL",IF(ISNUMBER(FIND("75CL",G25)),"75CL",IF(ISNUMBER(FIND("1L5",G25)),"1.5L",IF(ISNUMBER(FIND("1L",G25)),"1L","75CL")))),IF(U25="*",M25&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G25,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G25))-2),{1,2,3}))&"*",K25&"*"&L25&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G25),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J26=IF(LEFT(H26,4)<>"2008",IF(LEFT(H26)="2",IF(I26="WINES",K26&"*"&L26&"*"&IF(ISNUMBER(FIND(37.5,G26)),"37.5CL",IF(ISNUMBER(FIND("75CL",G26)),"75CL",IF(ISNUMBER(FIND("1L5",G26)),"1.5L",IF(ISNUMBER(FIND("1L",G26)),"1L","75CL")))),IF(U26="*",M26&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G26,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G26))-2),{1,2,3}))&"*",K26&"*"&L26&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G26),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J27=IF(LEFT(H27,4)<>"2008",IF(LEFT(H27)="2",IF(I27="WINES",K27&"*"&L27&"*"&IF(ISNUMBER(FIND(37.5,G27)),"37.5CL",IF(ISNUMBER(FIND("75CL",G27)),"75CL",IF(ISNUMBER(FIND("1L5",G27)),"1.5L",IF(ISNUMBER(FIND("1L",G27)),"1L","75CL")))),IF(U27="*",M27&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G27,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G27))-2),{1,2,3}))&"*",K27&"*"&L27&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G27),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J28=IF(LEFT(H28,4)<>"2008",IF(LEFT(H28)="2",IF(I28="WINES",K28&"*"&L28&"*"&IF(ISNUMBER(FIND(37.5,G28)),"37.5CL",IF(ISNUMBER(FIND("75CL",G28)),"75CL",IF(ISNUMBER(FIND("1L5",G28)),"1.5L",IF(ISNUMBER(FIND("1L",G28)),"1L","75CL")))),IF(U28="*",M28&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G28,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G28))-2),{1,2,3}))&"*",K28&"*"&L28&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G28),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J29=IF(LEFT(H29,4)<>"2008",IF(LEFT(H29)="2",IF(I29="WINES",K29&"*"&L29&"*"&IF(ISNUMBER(FIND(37.5,G29)),"37.5CL",IF(ISNUMBER(FIND("75CL",G29)),"75CL",IF(ISNUMBER(FIND("1L5",G29)),"1.5L",IF(ISNUMBER(FIND("1L",G29)),"1L","75CL")))),IF(U29="*",M29&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G29,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G29))-2),{1,2,3}))&"*",K29&"*"&L29&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G29),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J30=IF(LEFT(H30,4)<>"2008",IF(LEFT(H30)="2",IF(I30="WINES",K30&"*"&L30&"*"&IF(ISNUMBER(FIND(37.5,G30)),"37.5CL",IF(ISNUMBER(FIND("75CL",G30)),"75CL",IF(ISNUMBER(FIND("1L5",G30)),"1.5L",IF(ISNUMBER(FIND("1L",G30)),"1L","75CL")))),IF(U30="*",M30&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G30,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G30))-2),{1,2,3}))&"*",K30&"*"&L30&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G30),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J31=IF(LEFT(H31,4)<>"2008",IF(LEFT(H31)="2",IF(I31="WINES",K31&"*"&L31&"*"&IF(ISNUMBER(FIND(37.5,G31)),"37.5CL",IF(ISNUMBER(FIND("75CL",G31)),"75CL",IF(ISNUMBER(FIND("1L5",G31)),"1.5L",IF(ISNUMBER(FIND("1L",G31)),"1L","75CL")))),IF(U31="*",M31&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G31,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G31))-2),{1,2,3}))&"*",K31&"*"&L31&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G31),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J32=IF(LEFT(H32,4)<>"2008",IF(LEFT(H32)="2",IF(I32="WINES",K32&"*"&L32&"*"&IF(ISNUMBER(FIND(37.5,G32)),"37.5CL",IF(ISNUMBER(FIND("75CL",G32)),"75CL",IF(ISNUMBER(FIND("1L5",G32)),"1.5L",IF(ISNUMBER(FIND("1L",G32)),"1L","75CL")))),IF(U32="*",M32&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G32,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G32))-2),{1,2,3}))&"*",K32&"*"&L32&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G32),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J33=IF(LEFT(H33,4)<>"2008",IF(LEFT(H33)="2",IF(I33="WINES",K33&"*"&L33&"*"&IF(ISNUMBER(FIND(37.5,G33)),"37.5CL",IF(ISNUMBER(FIND("75CL",G33)),"75CL",IF(ISNUMBER(FIND("1L5",G33)),"1.5L",IF(ISNUMBER(FIND("1L",G33)),"1L","75CL")))),IF(U33="*",M33&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G33,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G33))-2),{1,2,3}))&"*",K33&"*"&L33&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G33),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J34=IF(LEFT(H34,4)<>"2008",IF(LEFT(H34)="2",IF(I34="WINES",K34&"*"&L34&"*"&IF(ISNUMBER(FIND(37.5,G34)),"37.5CL",IF(ISNUMBER(FIND("75CL",G34)),"75CL",IF(ISNUMBER(FIND("1L5",G34)),"1.5L",IF(ISNUMBER(FIND("1L",G34)),"1L","75CL")))),IF(U34="*",M34&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G34,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G34))-2),{1,2,3}))&"*",K34&"*"&L34&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G34),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J35=IF(LEFT(H35,4)<>"2008",IF(LEFT(H35)="2",IF(I35="WINES",K35&"*"&L35&"*"&IF(ISNUMBER(FIND(37.5,G35)),"37.5CL",IF(ISNUMBER(FIND("75CL",G35)),"75CL",IF(ISNUMBER(FIND("1L5",G35)),"1.5L",IF(ISNUMBER(FIND("1L",G35)),"1L","75CL")))),IF(U35="*",M35&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G35,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G35))-2),{1,2,3}))&"*",K35&"*"&L35&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G35),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J36=IF(LEFT(H36,4)<>"2008",IF(LEFT(H36)="2",IF(I36="WINES",K36&"*"&L36&"*"&IF(ISNUMBER(FIND(37.5,G36)),"37.5CL",IF(ISNUMBER(FIND("75CL",G36)),"75CL",IF(ISNUMBER(FIND("1L5",G36)),"1.5L",IF(ISNUMBER(FIND("1L",G36)),"1L","75CL")))),IF(U36="*",M36&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G36,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G36))-2),{1,2,3}))&"*",K36&"*"&L36&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G36),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J37=IF(LEFT(H37,4)<>"2008",IF(LEFT(H37)="2",IF(I37="WINES",K37&"*"&L37&"*"&IF(ISNUMBER(FIND(37.5,G37)),"37.5CL",IF(ISNUMBER(FIND("75CL",G37)),"75CL",IF(ISNUMBER(FIND("1L5",G37)),"1.5L",IF(ISNUMBER(FIND("1L",G37)),"1L","75CL")))),IF(U37="*",M37&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G37,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G37))-2),{1,2,3}))&"*",K37&"*"&L37&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G37),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J38=IF(LEFT(H38,4)<>"2008",IF(LEFT(H38)="2",IF(I38="WINES",K38&"*"&L38&"*"&IF(ISNUMBER(FIND(37.5,G38)),"37.5CL",IF(ISNUMBER(FIND("75CL",G38)),"75CL",IF(ISNUMBER(FIND("1L5",G38)),"1.5L",IF(ISNUMBER(FIND("1L",G38)),"1L","75CL")))),IF(U38="*",M38&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G38,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G38))-2),{1,2,3}))&"*",K38&"*"&L38&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G38),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J39=IF(LEFT(H39,4)<>"2008",IF(LEFT(H39)="2",IF(I39="WINES",K39&"*"&L39&"*"&IF(ISNUMBER(FIND(37.5,G39)),"37.5CL",IF(ISNUMBER(FIND("75CL",G39)),"75CL",IF(ISNUMBER(FIND("1L5",G39)),"1.5L",IF(ISNUMBER(FIND("1L",G39)),"1L","75CL")))),IF(U39="*",M39&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G39,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G39))-2),{1,2,3}))&"*",K39&"*"&L39&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G39),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J40=IF(LEFT(H40,4)<>"2008",IF(LEFT(H40)="2",IF(I40="WINES",K40&"*"&L40&"*"&IF(ISNUMBER(FIND(37.5,G40)),"37.5CL",IF(ISNUMBER(FIND("75CL",G40)),"75CL",IF(ISNUMBER(FIND("1L5",G40)),"1.5L",IF(ISNUMBER(FIND("1L",G40)),"1L","75CL")))),IF(U40="*",M40&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G40,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G40))-2),{1,2,3}))&"*",K40&"*"&L40&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G40),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J41=IF(LEFT(H41,4)<>"2008",IF(LEFT(H41)="2",IF(I41="WINES",K41&"*"&L41&"*"&IF(ISNUMBER(FIND(37.5,G41)),"37.5CL",IF(ISNUMBER(FIND("75CL",G41)),"75CL",IF(ISNUMBER(FIND("1L5",G41)),"1.5L",IF(ISNUMBER(FIND("1L",G41)),"1L","75CL")))),IF(U41="*",M41&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G41,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G41))-2),{1,2,3}))&"*",K41&"*"&L41&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G41),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J42=IF(LEFT(H42,4)<>"2008",IF(LEFT(H42)="2",IF(I42="WINES",K42&"*"&L42&"*"&IF(ISNUMBER(FIND(37.5,G42)),"37.5CL",IF(ISNUMBER(FIND("75CL",G42)),"75CL",IF(ISNUMBER(FIND("1L5",G42)),"1.5L",IF(ISNUMBER(FIND("1L",G42)),"1L","75CL")))),IF(U42="*",M42&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G42,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G42))-2),{1,2,3}))&"*",K42&"*"&L42&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G42),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J43=IF(LEFT(H43,4)<>"2008",IF(LEFT(H43)="2",IF(I43="WINES",K43&"*"&L43&"*"&IF(ISNUMBER(FIND(37.5,G43)),"37.5CL",IF(ISNUMBER(FIND("75CL",G43)),"75CL",IF(ISNUMBER(FIND("1L5",G43)),"1.5L",IF(ISNUMBER(FIND("1L",G43)),"1L","75CL")))),IF(U43="*",M43&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G43,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G43))-2),{1,2,3}))&"*",K43&"*"&L43&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G43),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J44=IF(LEFT(H44,4)<>"2008",IF(LEFT(H44)="2",IF(I44="WINES",K44&"*"&L44&"*"&IF(ISNUMBER(FIND(37.5,G44)),"37.5CL",IF(ISNUMBER(FIND("75CL",G44)),"75CL",IF(ISNUMBER(FIND("1L5",G44)),"1.5L",IF(ISNUMBER(FIND("1L",G44)),"1L","75CL")))),IF(U44="*",M44&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G44,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G44))-2),{1,2,3}))&"*",K44&"*"&L44&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G44),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J45=IF(LEFT(H45,4)<>"2008",IF(LEFT(H45)="2",IF(I45="WINES",K45&"*"&L45&"*"&IF(ISNUMBER(FIND(37.5,G45)),"37.5CL",IF(ISNUMBER(FIND("75CL",G45)),"75CL",IF(ISNUMBER(FIND("1L5",G45)),"1.5L",IF(ISNUMBER(FIND("1L",G45)),"1L","75CL")))),IF(U45="*",M45&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G45,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G45))-2),{1,2,3}))&"*",K45&"*"&L45&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G45),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J46=IF(LEFT(H46,4)<>"2008",IF(LEFT(H46)="2",IF(I46="WINES",K46&"*"&L46&"*"&IF(ISNUMBER(FIND(37.5,G46)),"37.5CL",IF(ISNUMBER(FIND("75CL",G46)),"75CL",IF(ISNUMBER(FIND("1L5",G46)),"1.5L",IF(ISNUMBER(FIND("1L",G46)),"1L","75CL")))),IF(U46="*",M46&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G46,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G46))-2),{1,2,3}))&"*",K46&"*"&L46&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G46),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J47=IF(LEFT(H47,4)<>"2008",IF(LEFT(H47)="2",IF(I47="WINES",K47&"*"&L47&"*"&IF(ISNUMBER(FIND(37.5,G47)),"37.5CL",IF(ISNUMBER(FIND("75CL",G47)),"75CL",IF(ISNUMBER(FIND("1L5",G47)),"1.5L",IF(ISNUMBER(FIND("1L",G47)),"1L","75CL")))),IF(U47="*",M47&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G47,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G47))-2),{1,2,3}))&"*",K47&"*"&L47&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G47),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J48=IF(LEFT(H48,4)<>"2008",IF(LEFT(H48)="2",IF(I48="WINES",K48&"*"&L48&"*"&IF(ISNUMBER(FIND(37.5,G48)),"37.5CL",IF(ISNUMBER(FIND("75CL",G48)),"75CL",IF(ISNUMBER(FIND("1L5",G48)),"1.5L",IF(ISNUMBER(FIND("1L",G48)),"1L","75CL")))),IF(U48="*",M48&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G48,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G48))-2),{1,2,3}))&"*",K48&"*"&L48&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G48),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J49=IF(LEFT(H49,4)<>"2008",IF(LEFT(H49)="2",IF(I49="WINES",K49&"*"&L49&"*"&IF(ISNUMBER(FIND(37.5,G49)),"37.5CL",IF(ISNUMBER(FIND("75CL",G49)),"75CL",IF(ISNUMBER(FIND("1L5",G49)),"1.5L",IF(ISNUMBER(FIND("1L",G49)),"1L","75CL")))),IF(U49="*",M49&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G49,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G49))-2),{1,2,3}))&"*",K49&"*"&L49&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G49),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J50=IF(LEFT(H50,4)<>"2008",IF(LEFT(H50)="2",IF(I50="WINES",K50&"*"&L50&"*"&IF(ISNUMBER(FIND(37.5,G50)),"37.5CL",IF(ISNUMBER(FIND("75CL",G50)),"75CL",IF(ISNUMBER(FIND("1L5",G50)),"1.5L",IF(ISNUMBER(FIND("1L",G50)),"1L","75CL")))),IF(U50="*",M50&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G50,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G50))-2),{1,2,3}))&"*",K50&"*"&L50&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G50),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J51=IF(LEFT(H51,4)<>"2008",IF(LEFT(H51)="2",IF(I51="WINES",K51&"*"&L51&"*"&IF(ISNUMBER(FIND(37.5,G51)),"37.5CL",IF(ISNUMBER(FIND("75CL",G51)),"75CL",IF(ISNUMBER(FIND("1L5",G51)),"1.5L",IF(ISNUMBER(FIND("1L",G51)),"1L","75CL")))),IF(U51="*",M51&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G51,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G51))-2),{1,2,3}))&"*",K51&"*"&L51&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G51),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J52=IF(LEFT(H52,4)<>"2008",IF(LEFT(H52)="2",IF(I52="WINES",K52&"*"&L52&"*"&IF(ISNUMBER(FIND(37.5,G52)),"37.5CL",IF(ISNUMBER(FIND("75CL",G52)),"75CL",IF(ISNUMBER(FIND("1L5",G52)),"1.5L",IF(ISNUMBER(FIND("1L",G52)),"1L","75CL")))),IF(U52="*",M52&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G52,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G52))-2),{1,2,3}))&"*",K52&"*"&L52&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G52),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J53=IF(LEFT(H53,4)<>"2008",IF(LEFT(H53)="2",IF(I53="WINES",K53&"*"&L53&"*"&IF(ISNUMBER(FIND(37.5,G53)),"37.5CL",IF(ISNUMBER(FIND("75CL",G53)),"75CL",IF(ISNUMBER(FIND("1L5",G53)),"1.5L",IF(ISNUMBER(FIND("1L",G53)),"1L","75CL")))),IF(U53="*",M53&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G53,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G53))-2),{1,2,3}))&"*",K53&"*"&L53&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G53),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J54=IF(LEFT(H54,4)<>"2008",IF(LEFT(H54)="2",IF(I54="WINES",K54&"*"&L54&"*"&IF(ISNUMBER(FIND(37.5,G54)),"37.5CL",IF(ISNUMBER(FIND("75CL",G54)),"75CL",IF(ISNUMBER(FIND("1L5",G54)),"1.5L",IF(ISNUMBER(FIND("1L",G54)),"1L","75CL")))),IF(U54="*",M54&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G54,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G54))-2),{1,2,3}))&"*",K54&"*"&L54&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G54),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J55=IF(LEFT(H55,4)<>"2008",IF(LEFT(H55)="2",IF(I55="WINES",K55&"*"&L55&"*"&IF(ISNUMBER(FIND(37.5,G55)),"37.5CL",IF(ISNUMBER(FIND("75CL",G55)),"75CL",IF(ISNUMBER(FIND("1L5",G55)),"1.5L",IF(ISNUMBER(FIND("1L",G55)),"1L","75CL")))),IF(U55="*",M55&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G55,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G55))-2),{1,2,3}))&"*",K55&"*"&L55&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G55),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J56=IF(LEFT(H56,4)<>"2008",IF(LEFT(H56)="2",IF(I56="WINES",K56&"*"&L56&"*"&IF(ISNUMBER(FIND(37.5,G56)),"37.5CL",IF(ISNUMBER(FIND("75CL",G56)),"75CL",IF(ISNUMBER(FIND("1L5",G56)),"1.5L",IF(ISNUMBER(FIND("1L",G56)),"1L","75CL")))),IF(U56="*",M56&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G56,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G56))-2),{1,2,3}))&"*",K56&"*"&L56&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G56),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J57=IF(LEFT(H57,4)<>"2008",IF(LEFT(H57)="2",IF(I57="WINES",K57&"*"&L57&"*"&IF(ISNUMBER(FIND(37.5,G57)),"37.5CL",IF(ISNUMBER(FIND("75CL",G57)),"75CL",IF(ISNUMBER(FIND("1L5",G57)),"1.5L",IF(ISNUMBER(FIND("1L",G57)),"1L","75CL")))),IF(U57="*",M57&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G57,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G57))-2),{1,2,3}))&"*",K57&"*"&L57&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G57),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J58=IF(LEFT(H58,4)<>"2008",IF(LEFT(H58)="2",IF(I58="WINES",K58&"*"&L58&"*"&IF(ISNUMBER(FIND(37.5,G58)),"37.5CL",IF(ISNUMBER(FIND("75CL",G58)),"75CL",IF(ISNUMBER(FIND("1L5",G58)),"1.5L",IF(ISNUMBER(FIND("1L",G58)),"1L","75CL")))),IF(U58="*",M58&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G58,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G58))-2),{1,2,3}))&"*",K58&"*"&L58&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G58),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J59=IF(LEFT(H59,4)<>"2008",IF(LEFT(H59)="2",IF(I59="WINES",K59&"*"&L59&"*"&IF(ISNUMBER(FIND(37.5,G59)),"37.5CL",IF(ISNUMBER(FIND("75CL",G59)),"75CL",IF(ISNUMBER(FIND("1L5",G59)),"1.5L",IF(ISNUMBER(FIND("1L",G59)),"1L","75CL")))),IF(U59="*",M59&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G59,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G59))-2),{1,2,3}))&"*",K59&"*"&L59&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G59),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J60=IF(LEFT(H60,4)<>"2008",IF(LEFT(H60)="2",IF(I60="WINES",K60&"*"&L60&"*"&IF(ISNUMBER(FIND(37.5,G60)),"37.5CL",IF(ISNUMBER(FIND("75CL",G60)),"75CL",IF(ISNUMBER(FIND("1L5",G60)),"1.5L",IF(ISNUMBER(FIND("1L",G60)),"1L","75CL")))),IF(U60="*",M60&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G60,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G60))-2),{1,2,3}))&"*",K60&"*"&L60&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G60),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J61=IF(LEFT(H61,4)<>"2008",IF(LEFT(H61)="2",IF(I61="WINES",K61&"*"&L61&"*"&IF(ISNUMBER(FIND(37.5,G61)),"37.5CL",IF(ISNUMBER(FIND("75CL",G61)),"75CL",IF(ISNUMBER(FIND("1L5",G61)),"1.5L",IF(ISNUMBER(FIND("1L",G61)),"1L","75CL")))),IF(U61="*",M61&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G61,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G61))-2),{1,2,3}))&"*",K61&"*"&L61&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G61),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J62=IF(LEFT(H62,4)<>"2008",IF(LEFT(H62)="2",IF(I62="WINES",K62&"*"&L62&"*"&IF(ISNUMBER(FIND(37.5,G62)),"37.5CL",IF(ISNUMBER(FIND("75CL",G62)),"75CL",IF(ISNUMBER(FIND("1L5",G62)),"1.5L",IF(ISNUMBER(FIND("1L",G62)),"1L","75CL")))),IF(U62="*",M62&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G62,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G62))-2),{1,2,3}))&"*",K62&"*"&L62&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G62),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J63=IF(LEFT(H63,4)<>"2008",IF(LEFT(H63)="2",IF(I63="WINES",K63&"*"&L63&"*"&IF(ISNUMBER(FIND(37.5,G63)),"37.5CL",IF(ISNUMBER(FIND("75CL",G63)),"75CL",IF(ISNUMBER(FIND("1L5",G63)),"1.5L",IF(ISNUMBER(FIND("1L",G63)),"1L","75CL")))),IF(U63="*",M63&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G63,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G63))-2),{1,2,3}))&"*",K63&"*"&L63&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G63),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J64=IF(LEFT(H64,4)<>"2008",IF(LEFT(H64)="2",IF(I64="WINES",K64&"*"&L64&"*"&IF(ISNUMBER(FIND(37.5,G64)),"37.5CL",IF(ISNUMBER(FIND("75CL",G64)),"75CL",IF(ISNUMBER(FIND("1L5",G64)),"1.5L",IF(ISNUMBER(FIND("1L",G64)),"1L","75CL")))),IF(U64="*",M64&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G64,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G64))-2),{1,2,3}))&"*",K64&"*"&L64&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G64),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J65=IF(LEFT(H65,4)<>"2008",IF(LEFT(H65)="2",IF(I65="WINES",K65&"*"&L65&"*"&IF(ISNUMBER(FIND(37.5,G65)),"37.5CL",IF(ISNUMBER(FIND("75CL",G65)),"75CL",IF(ISNUMBER(FIND("1L5",G65)),"1.5L",IF(ISNUMBER(FIND("1L",G65)),"1L","75CL")))),IF(U65="*",M65&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G65,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G65))-2),{1,2,3}))&"*",K65&"*"&L65&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G65),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J66=IF(LEFT(H66,4)<>"2008",IF(LEFT(H66)="2",IF(I66="WINES",K66&"*"&L66&"*"&IF(ISNUMBER(FIND(37.5,G66)),"37.5CL",IF(ISNUMBER(FIND("75CL",G66)),"75CL",IF(ISNUMBER(FIND("1L5",G66)),"1.5L",IF(ISNUMBER(FIND("1L",G66)),"1L","75CL")))),IF(U66="*",M66&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G66,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G66))-2),{1,2,3}))&"*",K66&"*"&L66&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G66),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J67=IF(LEFT(H67,4)<>"2008",IF(LEFT(H67)="2",IF(I67="WINES",K67&"*"&L67&"*"&IF(ISNUMBER(FIND(37.5,G67)),"37.5CL",IF(ISNUMBER(FIND("75CL",G67)),"75CL",IF(ISNUMBER(FIND("1L5",G67)),"1.5L",IF(ISNUMBER(FIND("1L",G67)),"1L","75CL")))),IF(U67="*",M67&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G67,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G67))-2),{1,2,3}))&"*",K67&"*"&L67&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G67),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J68=IF(LEFT(H68,4)<>"2008",IF(LEFT(H68)="2",IF(I68="WINES",K68&"*"&L68&"*"&IF(ISNUMBER(FIND(37.5,G68)),"37.5CL",IF(ISNUMBER(FIND("75CL",G68)),"75CL",IF(ISNUMBER(FIND("1L5",G68)),"1.5L",IF(ISNUMBER(FIND("1L",G68)),"1L","75CL")))),IF(U68="*",M68&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G68,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G68))-2),{1,2,3}))&"*",K68&"*"&L68&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G68),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J69=IF(LEFT(H69,4)<>"2008",IF(LEFT(H69)="2",IF(I69="WINES",K69&"*"&L69&"*"&IF(ISNUMBER(FIND(37.5,G69)),"37.5CL",IF(ISNUMBER(FIND("75CL",G69)),"75CL",IF(ISNUMBER(FIND("1L5",G69)),"1.5L",IF(ISNUMBER(FIND("1L",G69)),"1L","75CL")))),IF(U69="*",M69&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G69,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G69))-2),{1,2,3}))&"*",K69&"*"&L69&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G69),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J70=IF(LEFT(H70,4)<>"2008",IF(LEFT(H70)="2",IF(I70="WINES",K70&"*"&L70&"*"&IF(ISNUMBER(FIND(37.5,G70)),"37.5CL",IF(ISNUMBER(FIND("75CL",G70)),"75CL",IF(ISNUMBER(FIND("1L5",G70)),"1.5L",IF(ISNUMBER(FIND("1L",G70)),"1L","75CL")))),IF(U70="*",M70&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G70,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G70))-2),{1,2,3}))&"*",K70&"*"&L70&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G70),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J71=IF(LEFT(H71,4)<>"2008",IF(LEFT(H71)="2",IF(I71="WINES",K71&"*"&L71&"*"&IF(ISNUMBER(FIND(37.5,G71)),"37.5CL",IF(ISNUMBER(FIND("75CL",G71)),"75CL",IF(ISNUMBER(FIND("1L5",G71)),"1.5L",IF(ISNUMBER(FIND("1L",G71)),"1L","75CL")))),IF(U71="*",M71&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G71,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G71))-2),{1,2,3}))&"*",K71&"*"&L71&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G71),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J72=IF(LEFT(H72,4)<>"2008",IF(LEFT(H72)="2",IF(I72="WINES",K72&"*"&L72&"*"&IF(ISNUMBER(FIND(37.5,G72)),"37.5CL",IF(ISNUMBER(FIND("75CL",G72)),"75CL",IF(ISNUMBER(FIND("1L5",G72)),"1.5L",IF(ISNUMBER(FIND("1L",G72)),"1L","75CL")))),IF(U72="*",M72&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G72,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G72))-2),{1,2,3}))&"*",K72&"*"&L72&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G72),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J73=IF(LEFT(H73,4)<>"2008",IF(LEFT(H73)="2",IF(I73="WINES",K73&"*"&L73&"*"&IF(ISNUMBER(FIND(37.5,G73)),"37.5CL",IF(ISNUMBER(FIND("75CL",G73)),"75CL",IF(ISNUMBER(FIND("1L5",G73)),"1.5L",IF(ISNUMBER(FIND("1L",G73)),"1L","75CL")))),IF(U73="*",M73&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G73,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G73))-2),{1,2,3}))&"*",K73&"*"&L73&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G73),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J74=IF(LEFT(H74,4)<>"2008",IF(LEFT(H74)="2",IF(I74="WINES",K74&"*"&L74&"*"&IF(ISNUMBER(FIND(37.5,G74)),"37.5CL",IF(ISNUMBER(FIND("75CL",G74)),"75CL",IF(ISNUMBER(FIND("1L5",G74)),"1.5L",IF(ISNUMBER(FIND("1L",G74)),"1L","75CL")))),IF(U74="*",M74&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G74,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G74))-2),{1,2,3}))&"*",K74&"*"&L74&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G74),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J75=IF(LEFT(H75,4)<>"2008",IF(LEFT(H75)="2",IF(I75="WINES",K75&"*"&L75&"*"&IF(ISNUMBER(FIND(37.5,G75)),"37.5CL",IF(ISNUMBER(FIND("75CL",G75)),"75CL",IF(ISNUMBER(FIND("1L5",G75)),"1.5L",IF(ISNUMBER(FIND("1L",G75)),"1L","75CL")))),IF(U75="*",M75&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G75,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G75))-2),{1,2,3}))&"*",K75&"*"&L75&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G75),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J76=IF(LEFT(H76,4)<>"2008",IF(LEFT(H76)="2",IF(I76="WINES",K76&"*"&L76&"*"&IF(ISNUMBER(FIND(37.5,G76)),"37.5CL",IF(ISNUMBER(FIND("75CL",G76)),"75CL",IF(ISNUMBER(FIND("1L5",G76)),"1.5L",IF(ISNUMBER(FIND("1L",G76)),"1L","75CL")))),IF(U76="*",M76&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G76,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G76))-2),{1,2,3}))&"*",K76&"*"&L76&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G76),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J77=IF(LEFT(H77,4)<>"2008",IF(LEFT(H77)="2",IF(I77="WINES",K77&"*"&L77&"*"&IF(ISNUMBER(FIND(37.5,G77)),"37.5CL",IF(ISNUMBER(FIND("75CL",G77)),"75CL",IF(ISNUMBER(FIND("1L5",G77)),"1.5L",IF(ISNUMBER(FIND("1L",G77)),"1L","75CL")))),IF(U77="*",M77&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G77,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G77))-2),{1,2,3}))&"*",K77&"*"&L77&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G77),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J78=IF(LEFT(H78,4)<>"2008",IF(LEFT(H78)="2",IF(I78="WINES",K78&"*"&L78&"*"&IF(ISNUMBER(FIND(37.5,G78)),"37.5CL",IF(ISNUMBER(FIND("75CL",G78)),"75CL",IF(ISNUMBER(FIND("1L5",G78)),"1.5L",IF(ISNUMBER(FIND("1L",G78)),"1L","75CL")))),IF(U78="*",M78&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G78,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G78))-2),{1,2,3}))&"*",K78&"*"&L78&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G78),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J79=IF(LEFT(H79,4)<>"2008",IF(LEFT(H79)="2",IF(I79="WINES",K79&"*"&L79&"*"&IF(ISNUMBER(FIND(37.5,G79)),"37.5CL",IF(ISNUMBER(FIND("75CL",G79)),"75CL",IF(ISNUMBER(FIND("1L5",G79)),"1.5L",IF(ISNUMBER(FIND("1L",G79)),"1L","75CL")))),IF(U79="*",M79&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G79,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G79))-2),{1,2,3}))&"*",K79&"*"&L79&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G79),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J80=IF(LEFT(H80,4)<>"2008",IF(LEFT(H80)="2",IF(I80="WINES",K80&"*"&L80&"*"&IF(ISNUMBER(FIND(37.5,G80)),"37.5CL",IF(ISNUMBER(FIND("75CL",G80)),"75CL",IF(ISNUMBER(FIND("1L5",G80)),"1.5L",IF(ISNUMBER(FIND("1L",G80)),"1L","75CL")))),IF(U80="*",M80&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G80,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G80))-2),{1,2,3}))&"*",K80&"*"&L80&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G80),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J81=IF(LEFT(H81,4)<>"2008",IF(LEFT(H81)="2",IF(I81="WINES",K81&"*"&L81&"*"&IF(ISNUMBER(FIND(37.5,G81)),"37.5CL",IF(ISNUMBER(FIND("75CL",G81)),"75CL",IF(ISNUMBER(FIND("1L5",G81)),"1.5L",IF(ISNUMBER(FIND("1L",G81)),"1L","75CL")))),IF(U81="*",M81&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G81,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G81))-2),{1,2,3}))&"*",K81&"*"&L81&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G81),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J82=IF(LEFT(H82,4)<>"2008",IF(LEFT(H82)="2",IF(I82="WINES",K82&"*"&L82&"*"&IF(ISNUMBER(FIND(37.5,G82)),"37.5CL",IF(ISNUMBER(FIND("75CL",G82)),"75CL",IF(ISNUMBER(FIND("1L5",G82)),"1.5L",IF(ISNUMBER(FIND("1L",G82)),"1L","75CL")))),IF(U82="*",M82&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G82,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G82))-2),{1,2,3}))&"*",K82&"*"&L82&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G82),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J83=IF(LEFT(H83,4)<>"2008",IF(LEFT(H83)="2",IF(I83="WINES",K83&"*"&L83&"*"&IF(ISNUMBER(FIND(37.5,G83)),"37.5CL",IF(ISNUMBER(FIND("75CL",G83)),"75CL",IF(ISNUMBER(FIND("1L5",G83)),"1.5L",IF(ISNUMBER(FIND("1L",G83)),"1L","75CL")))),IF(U83="*",M83&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G83,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G83))-2),{1,2,3}))&"*",K83&"*"&L83&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G83),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J84=IF(LEFT(H84,4)<>"2008",IF(LEFT(H84)="2",IF(I84="WINES",K84&"*"&L84&"*"&IF(ISNUMBER(FIND(37.5,G84)),"37.5CL",IF(ISNUMBER(FIND("75CL",G84)),"75CL",IF(ISNUMBER(FIND("1L5",G84)),"1.5L",IF(ISNUMBER(FIND("1L",G84)),"1L","75CL")))),IF(U84="*",M84&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G84,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G84))-2),{1,2,3}))&"*",K84&"*"&L84&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G84),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J85=IF(LEFT(H85,4)<>"2008",IF(LEFT(H85)="2",IF(I85="WINES",K85&"*"&L85&"*"&IF(ISNUMBER(FIND(37.5,G85)),"37.5CL",IF(ISNUMBER(FIND("75CL",G85)),"75CL",IF(ISNUMBER(FIND("1L5",G85)),"1.5L",IF(ISNUMBER(FIND("1L",G85)),"1L","75CL")))),IF(U85="*",M85&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G85,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G85))-2),{1,2,3}))&"*",K85&"*"&L85&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G85),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J86=IF(LEFT(H86,4)<>"2008",IF(LEFT(H86)="2",IF(I86="WINES",K86&"*"&L86&"*"&IF(ISNUMBER(FIND(37.5,G86)),"37.5CL",IF(ISNUMBER(FIND("75CL",G86)),"75CL",IF(ISNUMBER(FIND("1L5",G86)),"1.5L",IF(ISNUMBER(FIND("1L",G86)),"1L","75CL")))),IF(U86="*",M86&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G86,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G86))-2),{1,2,3}))&"*",K86&"*"&L86&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G86),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J87=IF(LEFT(H87,4)<>"2008",IF(LEFT(H87)="2",IF(I87="WINES",K87&"*"&L87&"*"&IF(ISNUMBER(FIND(37.5,G87)),"37.5CL",IF(ISNUMBER(FIND("75CL",G87)),"75CL",IF(ISNUMBER(FIND("1L5",G87)),"1.5L",IF(ISNUMBER(FIND("1L",G87)),"1L","75CL")))),IF(U87="*",M87&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G87,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G87))-2),{1,2,3}))&"*",K87&"*"&L87&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G87),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J88=IF(LEFT(H88,4)<>"2008",IF(LEFT(H88)="2",IF(I88="WINES",K88&"*"&L88&"*"&IF(ISNUMBER(FIND(37.5,G88)),"37.5CL",IF(ISNUMBER(FIND("75CL",G88)),"75CL",IF(ISNUMBER(FIND("1L5",G88)),"1.5L",IF(ISNUMBER(FIND("1L",G88)),"1L","75CL")))),IF(U88="*",M88&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G88,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G88))-2),{1,2,3}))&"*",K88&"*"&L88&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G88),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J89=IF(LEFT(H89,4)<>"2008",IF(LEFT(H89)="2",IF(I89="WINES",K89&"*"&L89&"*"&IF(ISNUMBER(FIND(37.5,G89)),"37.5CL",IF(ISNUMBER(FIND("75CL",G89)),"75CL",IF(ISNUMBER(FIND("1L5",G89)),"1.5L",IF(ISNUMBER(FIND("1L",G89)),"1L","75CL")))),IF(U89="*",M89&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G89,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G89))-2),{1,2,3}))&"*",K89&"*"&L89&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G89),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J90=IF(LEFT(H90,4)<>"2008",IF(LEFT(H90)="2",IF(I90="WINES",K90&"*"&L90&"*"&IF(ISNUMBER(FIND(37.5,G90)),"37.5CL",IF(ISNUMBER(FIND("75CL",G90)),"75CL",IF(ISNUMBER(FIND("1L5",G90)),"1.5L",IF(ISNUMBER(FIND("1L",G90)),"1L","75CL")))),IF(U90="*",M90&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G90,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G90))-2),{1,2,3}))&"*",K90&"*"&L90&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G90),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
J91=IF(LEFT(H91,4)<>"2008",IF(LEFT(H91)="2",IF(I91="WINES",K91&"*"&L91&"*"&IF(ISNUMBER(FIND(37.5,G91)),"37.5CL",IF(ISNUMBER(FIND("75CL",G91)),"75CL",IF(ISNUMBER(FIND("1L5",G91)),"1.5L",IF(ISNUMBER(FIND("1L",G91)),"1L","75CL")))),IF(U91="*",M91&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G91,LOOKUP(9^9,FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G91))-2),{1,2,3}))&"*",K91&"*"&L91&"*")&LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L"},G91),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L"})),""),"")
W8=J8=V8
W9=J9=V9
W10=J10=V10
W11=J11=V11
W12=J12=V12
W13=J13=V13
W14=J14=V14
W15=J15=V15
W16=J16=V16
W18=J18=V18
W19=J19=V19
W20=J20=V20
W21=J21=V21
W22=J22=V22
W23=J23=V23
W24=J24=V24
W25=J25=V25
W26=J26=V26
W27=J27=V27
W28=J28=V28
W29=J29=V29
W30=J30=V30
W31=J31=V31
W32=J32=V32
W33=J33=V33
W34=J34=V34
W35=J35=V35
W36=J36=V36
W37=J37=V37
W38=J38=V38
W39=J39=V39
W40=J40=V40
W41=J41=V41
W42=J42=V42
W43=J43=V43
W44=J44=V44
W45=J45=V45
W46=J46=V46
W47=J47=V47
W48=J48=V48
W49=J49=V49
W50=J50=V50
W51=J51=V51
W52=J52=V52
W53=J53=V53
W54=J54=V54
W55=J55=V55
W56=J56=V56
W57=J57=V57
W58=J58=V58
W59=J59=V59
W60=J60=V60
W61=J61=V61
W62=J62=V62
W63=J63=V63
W64=J64=V64
W65=J65=V65
W66=J66=V66
W67=J67=V67
W68=J68=V68
W69=J69=V69
W70=J70=V70
W71=J71=V71
W72=J72=V72
W73=J73=V73
W74=J74=V74
W75=J75=V75
W76=J76=V76
W77=J77=V77
W78=J78=V78
W79=J79=V79
W80=J80=V80
W81=J81=V81
W82=J82=V82
W83=J83=V83
W84=J84=V84
W85=J85=V85
W86=J86=V86
W87=J87=V87
W88=J88=V88
W89=J89=V89
W90=J90=V90
W91=J91=V91
W92=J92=V92
W93=J93=V93
W94=J94=V94
 
Upvote 0
@learn99: Please attach the google worksheet with the latest/updated formulae, and confirm on a couple of row nums where the issue is being encountered.
 
Upvote 0
.. and if posting further screen shots in the forum (which does attract more helpers as many are prevented from downloading from other sites by workplace restrictions), please look at options in the HTML maker for restricting the number of formulas shown. There is generally no need to display multiple formulas that are basically the same, it just fills up the board and makes your post and the thread hard to read/navigate.
 
Upvote 0
Here is a list where I have some issues with description , the N/A can be be used with iferror as last resort as data is heavy but some litrage I suspect some tuning in the formula for 3L to litres .

But still some issues with gram and soup preparation .

Formula used as per post 12 which needs some tuning

https://drive.google.com/file/d/1vuh1MjkqdfImnyVxApguEiQjIu9pTIwm/view?usp=sharing

GHIJKLMUV
BOUTON DOR OIGNON BLANCS 190G
ELOI MELANGE DE CHAMPIGNON230G
PAQUITO S/SUCRE MENTHE 2.5LJUICES
PAQUITO S/SUCRE GRENADINE 5LJUICES
FIORINI SAUCE PESTO ROSSO 190G
ELOI MELANG P.CHAMP LARDON270G
POMMETTE PT FRUIT POMME 2X120G
PAQUITO SIROP GRENADINE BLE5LSYRUP6*7*5L
PATURAGES CREME DESS.VANIL.510
IDS KIT ENCHILADAS 517G
FIORINI CANNELLONI 800GR
COTTERLEY INF.DU SOIR BIO 30G
ST ESTEPHE RG EXP CLUB 5LWINES6*6*5L
ST EMILION ROUGE CHT 4LWINES6*5*4L
WINES6*9*2L
WINES6*2*2.5L
WINES6*5*3L
ELODIE COMPOTE POMME MORC.600GCOMPOTE
TB COMPOTE POMME ALLEGEE 720MLCOMPOTE
PAQUITO MARMEL. ORANG.ALL.335GJAMS
T.BUDGET CONFITURE ABRICOTS KGJAMS
S.ELOI SOUP.CHANTRLLE&BOLET 1LSOUP PREPARATION
ST ELOI VEL.CAROT/CREME 2X30CLSOUP PREPARATION
ST ELOI VELOUTE EPIN/ARTICH 1LSOUP PREPARATION
S.ELOI POTAGE POULE AU POT 72GHOMOGENISED FOODS
BOUT.OR VINAIGR.BALSAMIQ.0.50L6*11*50CL
BOUT.OR VINAIGRE DE CIDRE 3LVINEGAR6*62*1L
BOUT.OR VINAIGRE DE CIDRE 5LVINEGAR6*62*1L
BOUT.OR VINAIGRE DE CIDRE 1L5VINEGAR6*62*1L

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=5B9BD5]#5B9BD5[/URL] , align: center"]DESIGNATION[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=5B9BD5]#5B9BD5[/URL] , align: center"]Tariff No [/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=5B9BD5]#5B9BD5[/URL] , align: center"]Description[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=5B9BD5]#5B9BD5[/URL] , align: right"]Pack Size Description[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=5B9BD5]#5B9BD5[/URL] , align: center"]CNDT[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=5B9BD5]#5B9BD5[/URL] , align: center"]Qte Cndt[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=5B9BD5]#5B9BD5[/URL] , align: center"]QTE UVC[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: center"][/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=5B9BD5]#5B9BD5[/URL] , align: right"]expected results [/TD]

[TD="align: center"]2[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]20019090[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]PRESERVED VEGETABLES[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]#N/A[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]192[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]20031000[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]PRESERVED MUSHROOM[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "]16*10*30CL[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]160[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "]S/CELORRIO ASPERGE POINTE212ML[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]20056000[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]PRESERVED ASPARAGUS[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]#N/A[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]63[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]

[TD="align: right"]20098900[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]#N/A[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]66[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"][/TD]
[TD="align: right"]6*11*2.5L[/TD]

[TD="align: center"]6[/TD]

[TD="align: right"]20098900[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]#N/A[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]13[/TD]
[TD="align: right"]78[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"][/TD]
[TD="align: right"]6*13*5L[/TD]

[TD="align: center"]7[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]21039090[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]SAUCE PREPARATION[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]#N/A[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]21041000[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]SOUP PREPARATION[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "]18*5*70CL[/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]90[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]21042000[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]HOMOGENISED FOODS[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]#N/A[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]222[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]

[TD="align: right"]21069060[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]#N/A[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]42[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"][/TD]

[TD="align: center"]11[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]21069090[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]TOPPINGS[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]#N/A[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]60[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]12[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]21069090[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]FOOD PREP.[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]#N/A[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]112[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]13[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]21069090[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]FOOD PREP.[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]#N/A[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]114[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]14[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]21069090[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]INFUSIONS[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "]6*32*30CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]192[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]

[TD="align: right"]22041090[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "]6*6*75CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]36[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"][/TD]

[TD="align: center"]16[/TD]

[TD="align: right"]22041090[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "]6*5*75CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]30[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"][/TD]

[TD="align: center"]17[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "]LALAN.POMEROL TOUR ST ANDRE 2L[/TD]
[TD="align: right"]22041090[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "]6*9*75CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]54[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"][/TD]

[TD="align: center"]18[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "]BORDEAUX BLANC MOELLEUX 2.5L[/TD]
[TD="align: right"]22041090[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "]6*2*75CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]12[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"][/TD]

[TD="align: center"]19[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "]BDX BLANC SEC E.CLUB MIL 3L[/TD]
[TD="align: right"]22041090[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "]6*5*75CL[/TD]
[TD="align: right"]6[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]30[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"][/TD]

[TD="align: center"]20[/TD]

[TD="align: right"]20079900[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]#N/A[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]264[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]21[/TD]

[TD="align: right"]20079900[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]#N/A[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]600[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]22[/TD]

[TD="align: right"]20079900[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "]24*1*33CL[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]23[/TD]

[TD="align: right"]20079900[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] , align: right"]#N/A[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]48[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]24[/TD]

[TD="align: right"]21041000[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "]10*17*1L[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]17[/TD]
[TD="align: right"]170[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]25[/TD]

[TD="align: right"]21041000[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "]24*11*30CL[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]264[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]26[/TD]

[TD="align: right"]21041000[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=FFFF00]#FFFF00[/URL] "]24*14*1L[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]336[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]27[/TD]

[TD="align: right"]21042000[/TD]

[TD="align: right"]#N/A[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]460[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]28[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] , align: right"]22090090[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CCFFCC]#CCFFCC[/URL] "]VINEGAR[/TD]

[TD="align: right"]6[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]66[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6*11*0.5L[/TD]

[TD="align: center"]29[/TD]

[TD="align: right"]22090090[/TD]

[TD="align: right"]6[/TD]
[TD="align: right"]62[/TD]
[TD="align: right"]372[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6*62*3L[/TD]

[TD="align: center"]30[/TD]

[TD="align: right"]22090090[/TD]

[TD="align: right"]6[/TD]
[TD="align: right"]62[/TD]
[TD="align: right"]372[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6*62*5L[/TD]

[TD="align: center"]31[/TD]

[TD="align: right"]22090090[/TD]

[TD="align: right"]6[/TD]
[TD="align: right"]62[/TD]
[TD="align: right"]372[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6*62*1L5[/TD]

</tbody>
SPLIT (3)​
 
Upvote 0
Pls edit the formula:
=IF(AND(LEFT(H2)="2",LEFT(H2,4)<>"2008"),IF(I2="WINES",K2&"*"&L2&"*"&IFERROR(LOOKUP(1,-FIND({37.5;75;"5L";"2L";"1.5L";"1L";"3L";"5L"},G2),{"37.5CL";"75CL";"5L";"2L";"1.5L";"1L";"3L";"5L"}),"75CL"),IF(U2="*",M2&"*"&LOOKUP(9^9,0+RIGHT(LEFT(G2,LOOKUP(9^9,FIND("X",G2,ROW($1:$99)))-1),{1,2,3}))&"*",K2&"*"&L2&"*")&LOOKUP(1,-FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5"},G2),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L"})),"")

especially this part: LEFT(H2,4)<>"2008") in accordance with your data, in order that, the tariff number be taken only corresponding to the entries in cL or L...

Please revert if there still is some issue.
Also, please indicate the problem is encountered in which particular cell..
 
Upvote 0
Hi

Thank you for the formula .

Was testing throughly , just encountered an issue so far with a particular line

as below got n/a .

Could use iferror , but I fear it slowed down the calculation on a big spreadsheet

Can you have alook it should show blank

Code: 
[TABLE="width: 1506"]
<tbody>[TR]
[TD="class: xl70, width: 82"]AAA[/TD]
[TD="width: 63, align: right"]19019099[/TD]
[TD="width: 103, align: right"]17382442[/TD]
[TD="width: 347"]PATURAGES CREME DESS.VANIL.510[/TD]
[TD="class: xl71, width: 91, align: right"]21069090[/TD]
[TD="class: xl71, width: 180"]TOPPINGS[/TD]
[TD="class: xl75, width: 139, align: center"]#N/A[/TD]
[TD="width: 41, align: right"]12[/TD]
[TD="width: 62, align: right"]5[/TD]
[TD="width: 61, align: right"]60[/TD]
[TD="width: 65"][/TD]
[TD="width: 86"][/TD]
[TD="class: xl72, width: 14"][/TD]
[TD="width: 109"][/TD]
[TD="class: xl69, width: 63, align: center"]#N/A[/TD]
[/TR]
</tbody>[/TABLE]
 
Last edited:
Upvote 0
@learn99: Once the formula is successful, I would advise you to paste the values, in order that the workbook does not get unnecessarily heavy.
Also, regarding this #N/A problem, since the description says,"PATURAGES CREME DESS.VANIL.510", please let me know what should be the valid outcome??
 
Upvote 0
You must log in or register to reply here.

Forum statistics

Threads
1,223,911
Messages
6,175,325
Members
452,635
Latest member
laura12345

Share this page

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