You have identified the problem. The formula stops here:
=IF(LEFT(H11)="2",IF(I11="WINES",K11&"*"&L11&"*"&IF(ISNUMBER(FIND(37.5,G11)),"37.5CL","75CL"), ...
If it does not find 37.5 in G11 (which it doesn't), it returns 75CL. So Excel can't go any further with it because it has found a match. You need to introduce another IF statement to deal with the 75CL requirement.
This should resolve the issue with row 11 (but not other issues you have flagged in your attachment):
=IF(LEFT(H4)="2",IF(I4="WINES",K4&"*"&L4&"*"&IFNA(LOOKUP(2,1/FIND({25;30;33;50;70;75;100;"1L";"1.5L";"1L5";"2L";"37.5CL"},G4),{"25CL";"30CL";"33CL";"50CL";"70CL";"75CL";"100CL";"1L";"1.5L";"1.5L";"2L";"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"})),"")
Bookmarks