I have worksheet which need to extract data starting from column K,L,M and G and insert in columns J
normal split, extract from columns K, L and from G, the word 1L resulting in J 16*4*1L
The second split type extract from column M and G and insert in J resulting to 2*6*1.5l
Third type of split extract from column K and L but criteria column H code by default and assign 75 cl.
those who are highlighted in yellow * are tricky .
Only part formula solution have been found so far

=IF(I9="WINES",K9&"*"&L9&"*"&IF(ISNUMBER(FIND(37.5,G9)),"37.5CL","75CL"),IF(I9="LIQUEURS",K9&"*"&L9&"*"&LOOKUP(2,1/FIND({50;70;100;"1L"},G9),{"50CL";"70CL";"100CL";"1L"}),""))
http://forum.chandoo.org/threads/for...2/#post-212406
Bookmarks