complex split formula to merge as per description

[learn99]

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 .

	F	G	H	I	J	K	L	M	X	Y
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]

 

[asakhy]

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"})),"")

 

[asakhy]

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...

 

[learn99]

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

 

[learn99]

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
	H	I	J	K	L	M	U	V	W
1	Tariff No	Description	Pack Size Description	CNDT	Qte Cndt	QTE UVC		expected results	Checking
2	20019090	PRESERVED VEGETABLES	#N/A	16	12	192
3	20019090	PRESERVED VEGETABLES	#N/A	6	10	60
4	20021000	PRESERVED TOMATOES	#N/A	12	6	72
5	20021000	PRESERVED TOMATOES	#N/A	6	8	48
6	20031000	PRESERVED MUSHROOM	16*10*30CL	16	10	160
7	20056000	PRESERVED ASPARAGUS	#N/A	9	7	63
8	20081900	PREPARED NUTS		22	14	308			TRUE
9	20089900	PREPARED FRUITS		32	5	160			TRUE
10	20089900	MIX FRUIT MELANGE		18	15	270			TRUE
11	20091200	ORANGE JUICES	16*7*1L	16	7	112		16*7*1L	TRUE
12	20091200	GRAPEFRUIT JUICE	16*7*1L	16	7	112		16*7*1L	TRUE
13	20098900	JUICES	6*11*2L	6	11	66		6*11*2L	TRUE
14	20098900	JUICES	#N/A	6	11	66		6*11*2.5L	#N/A
15	20098900	JUICES	#N/A	6	13	78		6*13*5L	#N/A
16	20099000	MIXED JUICES	#N/A	16	7	112		16*7*3.5L	#N/A
17	21032000	TOMATO SAUCE	#N/A	8	7	56
18	21039090	SAUCE PREPARATION	#N/A	6	44	264			#N/A
19	21039090	SAUCE PREPARATION	#N/A	6	5	30			#N/A
20	21041000	SOUP PREPARATION	18*5*70CL	18	5	90			FALSE
21	21042000	HOMOGENISED FOODS	#N/A	6	37	222			#N/A
22	21069060	SYRUP	6*6*1L	6	6	36		6*6*1L	TRUE
23	21069060	SYRUP	6*7*1L	6	7	42		6*7*1L	TRUE
24	21069060	SYRUP	#N/A	6	7	42		6*7*5L	#N/A
25	21069060	SYRUP	6*6*1.5L	6	6	36		6*6*1.5L	TRUE
26	21069060	SYRUP	6*7*2L	6	7	42		6*7*75CL	FALSE
27	21069090	TOPPINGS	#N/A	12	5	60			#N/A
28	21069090	FOOD PREP.	#N/A	16	7	112			#N/A
29	21069090	FOOD PREP.	#N/A	6	19	114			#N/A
30	21069090	INFUSIONS	6*32*30CL	6	32	192			FALSE
31	22011011	MINERAL WATER	105*6*1.5L	1	105	105	*	105*6*1.5L	TRUE
32	22011011	MINERAL WATER	39*6*1L	1	39	39	*	39*6*1L	TRUE
33	22011011	MINERAL WATER	104*6*1.5L	1	104	104	*	104*6*1.5L	TRUE
34	22011011	MINERAL WATER	56*6*1.5L	56	1	56	*	56*6*1.5L	TRUE
35	22011011	MINERAL WATER	28*6*50CL	4	7	28	*	28*6*50CL	TRUE
36	22011011	MINERAL WATER	36*6*50CL	4	9	36	*	36*6*50CL	TRUE
37	22011011	MINERAL WATER	6*11*1.5L	6	11	66		6*11*1.5L	TRUE
38	22021091	FRUIT JUICE	6*13*75CL	6	13	78		6*13*75CL	TRUE
39	22021091	FRUIT JUICE	6*10*75CL	6	10	60		6*10*75CL	TRUE
40	22021091	FRUIT JUICE	6*13*75CL	6	13	78		6*13*75CL	TRUE
41	22021091	FRUIT JUICE	6*35*1L	6	35	210		6*35*1L	TRUE
42	22021091	FRUIT JUICE	6*50*2L	6	50	300		6*50*2L	TRUE
43	22021091	FRUIT JUICE	6*70*2L	6	70	420		6*70*2L	TRUE
44	22029970	ICE TEA	6*30*75CL	6	30	180		6*30*75CL	TRUE
45	22029970	ICE TEA	6*12*2L	6	12	72		6*12*2L	TRUE
46	22029970	ICE TEA	6*30*1.5L	6	30	180		6*30*1.5L	TRUE
47	22029970	ICE TEA	6*30*1.5L	6	30	180		6*30*1.5L	TRUE
48	22029990	BEVERAGES	6*69*1L	6	69	414		6*69*1L	TRUE
49	22041090	WINES	12*5*37.5CL	12	5	60		12*5*37.5CL	TRUE
50	22041090	WINES	6*6*75CL	6	6	36		6*6*5L	FALSE
51	22041090	WINES	6*5*75CL	6	5	30		6*5*4L	FALSE
52	22041090	WINES	6*8*75CL	6	8	48		6*8*75CL	TRUE
53	22041090	WINES	6*6*75CL	6	6	36		6*6*5L	FALSE
54	22041090	WINES	6*9*1.5L	6	9	54		6*9*1.5L	TRUE
55	22041090	WINES	6*9*75CL	6	9	54		6*9*2L	FALSE
56	22041090	WINES	6*3*1L	6	3	18		6*3*1L	TRUE
57	22041090	WINES	6*2*75CL	6	2	12		6*2*2.5L	FALSE
58	22041090	WINES	6*5*75CL	6	5	30		6*5*3L	FALSE
59	22060039	SHANDY	134*10*25CL	2	67	134	*	134*10*25CL	TRUE
60	22087019	LIQUEURS	6*9*70CL	6	9	54		6*9*75CL	FALSE
61	22087019	LIQUEURS	6*32*70CL	6	32	192		6*32*75CL	FALSE
62	22087019	LIQUEURS	6*23*70CL	6	23	138		6*23*70CL	TRUE
63	22087019	LIQUEURS	6*5*70CL	6	5	30		6*5*70CL	TRUE
64	22087019	LIQUEURS	6*3*70CL	6	3	18		6*3*70CL	TRUE
65	22087019	LIQUEURS	6*5*50CL	6	5	30		6*5*50CL	TRUE
66	04090000	HONEY		8	13	104			TRUE
67	08021200	ALMONDS		6	14	84			TRUE
68	09012100	COFFEE		24	5	120			TRUE
69	11063000	VEG. POWDER		6	2	12			TRUE
70	19053100	BISCUITS		10	4	40			TRUE
71	19053100	BISCUITS		10	15	150			TRUE
72	19054090	TOASTED BREAD		12	5	60			TRUE
73	19054090	TOASTED BREAD		12	26	312			TRUE
74	20079900	COMPOTE	#N/A	16	20	320			#N/A
75	20079900	COMPOTE	#N/A	24	11	264			#N/A
76	20079900	COMPOTE	#N/A	24	25	600			#N/A
77	20079900	COMPOTE	#N/A	20	13	260			#N/A
78	20079900	JAMS	#N/A	24	24	576			#N/A
79	20079900	JAMS	24*1*33CL	24	1	24			FALSE
80	20079900	JAMS	#N/A	16	3	48			#N/A
81	21041000	SOUP PREPARATION	#N/A	10	16	160			#N/A
82	21041000	SOUP PREPARATION	#N/A	10	16	160			#N/A
83	21041000	SOUP PREPARATION	10*17*1L	10	17	170			FALSE
84	21041000	SOUP PREPARATION	24*11*30CL	24	11	264			FALSE
85	21041000	SOUP PREPARATION	24*14*1L	24	14	336			FALSE
86	21042000	HOMOGENISED FOODS	#N/A	20	23	460			#N/A
87	22029910	SOJA DRINK	15*22*1L	15	22	330		15*22*1L	TRUE
88	22087019	LIQUEURS	12*19*70CL	12	19	228		12*19*70CL	TRUE
89	22090090	VINEGAR	6*11*50CL	6	11	66		6*11*0.5L	FALSE
90	22090090	VINEGAR	6*62*75CL	6	62	372		6*62*75CL	TRUE
91	22090090	VINEGAR	6*62*1L	6	62	372		6*62*1L	TRUE
92	22090090	VINEGAR	6*62*1L	6	62	372		6*62*3L	FALSE
93	22090090	VINEGAR	6*62*1L	6	62	372		6*62*5L	FALSE
94	22090090	VINEGAR	6*62*1L	6	62	372		6*62*1L5	FALSE
SPLIT (2)

Cell Formulas
Range	Formula
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

 

[asakhy]

@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.

 

[Peter_SSs]

.. 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.

 

[learn99]

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

	G	H	I	J	K	L	M	U	V
BOUTON DOR OIGNON BLANCS 190G
ELOI MELANGE DE CHAMPIGNON230G
PAQUITO S/SUCRE MENTHE 2.5L	JUICES
PAQUITO S/SUCRE GRENADINE 5L	JUICES
FIORINI SAUCE PESTO ROSSO 190G
ELOI MELANG P.CHAMP LARDON270G
POMMETTE PT FRUIT POMME 2X120G
PAQUITO SIROP GRENADINE BLE5L	SYRUP	6*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 5L	WINES	6*6*5L
ST EMILION ROUGE CHT 4L	WINES	6*5*4L
WINES	6*9*2L
WINES	6*2*2.5L
WINES	6*5*3L
ELODIE COMPOTE POMME MORC.600G	COMPOTE
TB COMPOTE POMME ALLEGEE 720ML	COMPOTE
PAQUITO MARMEL. ORANG.ALL.335G	JAMS
T.BUDGET CONFITURE ABRICOTS KG	JAMS
S.ELOI SOUP.CHANTRLLE&BOLET 1L	SOUP PREPARATION
ST ELOI VEL.CAROT/CREME 2X30CL	SOUP PREPARATION
ST ELOI VELOUTE EPIN/ARTICH 1L	SOUP PREPARATION
S.ELOI POTAGE POULE AU POT 72G	HOMOGENISED FOODS
BOUT.OR VINAIGR.BALSAMIQ.0.50L	6*11*50CL
BOUT.OR VINAIGRE DE CIDRE 3L	VINEGAR	6*62*1L
BOUT.OR VINAIGRE DE CIDRE 5L	VINEGAR	6*62*1L
BOUT.OR VINAIGRE DE CIDRE 1L5	VINEGAR	6*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)​

 

[asakhy]

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..

 

[learn99]

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

[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]

 

[asakhy]

@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??