I have a worksheet which splits column K,l G,and merge them in column J
However I have trouble with description of wines in which there are 37.5 cl ,and 75 cl but there is an additional conversion of 1L for wines , tried to add in the red line but did not work
Can anyone assist should read 12*2*1L as per row 11which causing me trouble .
My apologies here the link
https://chandoo.org/forum/threads/to...-litres.38044/
=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"})),"")
Bookmarks