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
1	CODE ARTICLE	DESIGNATION	Tariff No	Description	Pack Size Description	CNDT	Qte Cndt	QTE UVC
2	17017154	BOUTON OR CROUT.AIL&F.HERBE60G	19054090	TOASTED BREAD		20	6	120
3	17082321	CHABRIOR *******S NATURE 250G	19059090	BISCUITS		12	25	300
4	17118363	PAQUITO SIROP CITRON.VRT 75CL	21069060	SYRUP	6*5*75CL	6	5	30
5	17311278	AIX LES BAINS EAU MIN 6X1L5	22011011	MINERAL WATER	105*6*1.5L	1	105	105
6	17311280	AIX LES BAINS E.MINERALE 6X1L	22011011	MINERAL WATER	39*6*1L	1	39	39
7	17314311	BROCELIANDE EAU MIN6X1L5 FARD	22011011	MINERAL WATER	104*6*1.5L	1	104	104
8	17314605	ONDINE E.DE SOURCE 6X1L5 1/2P	22011011	MINERAL WATER	56*6*1.5L	56	1	56
9	17330954	BABV BLC MANGUE E.CLUB	22041090	WINES	6*1*75CL	6	1	6
10	41027155	CHABRIOR GENOISE CITRON 150G	19053100	BISCUITS		24	10	240
11	52335060	VIN ESPAGNE BLC MOELCALISSOU1L	22041090	WINES	12*2*75CL	12	2	24	should read 12*2*1L in column J
12	52337011	VDP CX PIN ROUGE SYRAH	22041090	WINES	6*14*75CL	6	14	84
13	52337025	VDPOC CAB.SAUV RG XPIN 37.5CL	22041090	WINES	12*5*37.5CL	12	5	60
14	52337073	VDP OC MERLOT RGE X PIN BIB5L	22041090	WINES	4*12*75CL	4	12	48
15	52337077	VDP CX PIN ROUGE MERLOT 75CL	22041090	WINES	6*39*75CL	6	39	234
16	52337300	GAMAY RGE CHARENTAIS 75CL	22041090	WINES	12*3*75CL	12	3	36
17	52337602	VDP CX PIN RGE CAB.SAUVIGN75CL	22041090	WINES	6*43*75CL	6	43	258
18	52338041	VDP CX DU PIN BLC CHARDONN75CL	22041090	WINES	6*5*75CL	6	5	30

<tbody>
</tbody>

SPLIT SPIRITS (2)​

Worksheet Formulas Cell Formula J2 =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"})),"") J3 =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"})),"") J4 =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"})),"") J5 =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"})),"") J6 =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"})),"") J7 =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"})),"") J8 =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"})),"") J9 =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"})),"") J10 =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"})),"") J11 =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"})),"") J12 =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"})),"") J13 =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"})),"") J14 =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"})),"") J15 =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"})),"") J16 =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"})),"") J17 =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"})),"") J18 =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"})),"") <tbody> </tbody>

<tbody>
</tbody>

 

[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
1	DESIGNATION	Tariff No	Description	Pack Size Description	CNDT	Qte Cndt	QTE UVC		expected results
2	BOUTON DOR OIGNON BLANCS 190G	20019090	PRESERVED VEGETABLES	#N/A	16	12	192
3	ELOI MELANGE DE CHAMPIGNON230G	20031000	PRESERVED MUSHROOM	16*10*30CL	16	10	160
4	S/CELORRIO ASPERGE POINTE212ML	20056000	PRESERVED ASPARAGUS	#N/A	9	7	63
5	PAQUITO S/SUCRE MENTHE 2.5L	20098900	JUICES	#N/A	6	11	66		6*11*2.5L
6	PAQUITO S/SUCRE GRENADINE 5L	20098900	JUICES	#N/A	6	13	78		6*13*5L
7	FIORINI SAUCE PESTO ROSSO 190G	21039090	SAUCE PREPARATION	#N/A	6	5	30
8	ELOI MELANG P.CHAMP LARDON270G	21041000	SOUP PREPARATION	18*5*70CL	18	5	90
9	POMMETTE PT FRUIT POMME 2X120G	21042000	HOMOGENISED FOODS	#N/A	6	37	222
10	PAQUITO SIROP GRENADINE BLE5L	21069060	SYRUP	#N/A	6	7	42		6*7*5L
11	PATURAGES CREME DESS.VANIL.510	21069090	TOPPINGS	#N/A	12	5	60
12	IDS KIT ENCHILADAS 517G	21069090	FOOD PREP.	#N/A	16	7	112
13	FIORINI CANNELLONI 800GR	21069090	FOOD PREP.	#N/A	6	19	114
14	COTTERLEY INF.DU SOIR BIO 30G	21069090	INFUSIONS	6*32*30CL	6	32	192
15	ST ESTEPHE RG EXP CLUB 5L	22041090	WINES	6*6*75CL	6	6	36		6*6*5L
16	ST EMILION ROUGE CHT 4L	22041090	WINES	6*5*75CL	6	5	30		6*5*4L
17	LALAN.POMEROL TOUR ST ANDRE 2L	22041090	WINES	6*9*75CL	6	9	54		6*9*2L
18	BORDEAUX BLANC MOELLEUX 2.5L	22041090	WINES	6*2*75CL	6	2	12		6*2*2.5L
19	BDX BLANC SEC E.CLUB MIL 3L	22041090	WINES	6*5*75CL	6	5	30		6*5*3L
20	ELODIE COMPOTE POMME MORC.600G	20079900	COMPOTE	#N/A	24	11	264
21	TB COMPOTE POMME ALLEGEE 720ML	20079900	COMPOTE	#N/A	24	25	600
22	PAQUITO MARMEL. ORANG.ALL.335G	20079900	JAMS	24*1*33CL	24	1	24
23	T.BUDGET CONFITURE ABRICOTS KG	20079900	JAMS	#N/A	16	3	48
24	S.ELOI SOUP.CHANTRLLE&BOLET 1L	21041000	SOUP PREPARATION	10*17*1L	10	17	170
25	ST ELOI VEL.CAROT/CREME 2X30CL	21041000	SOUP PREPARATION	24*11*30CL	24	11	264
26	ST ELOI VELOUTE EPIN/ARTICH 1L	21041000	SOUP PREPARATION	24*14*1L	24	14	336
27	S.ELOI POTAGE POULE AU POT 72G	21042000	HOMOGENISED FOODS	#N/A	20	23	460
28	BOUT.OR VINAIGR.BALSAMIQ.0.50L	22090090	VINEGAR	6*11*50CL	6	11	66		6*11*0.5L
29	BOUT.OR VINAIGRE DE CIDRE 3L	22090090	VINEGAR	6*62*1L	6	62	372		6*62*3L
30	BOUT.OR VINAIGRE DE CIDRE 5L	22090090	VINEGAR	6*62*1L	6	62	372		6*62*5L
31	BOUT.OR VINAIGRE DE CIDRE 1L5	22090090	VINEGAR	6*62*1L	6	62	372		6*62*1L5

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</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??