Hello,
Hoping someone can help me understand the logic in this formula...what cells is it referencing? If I want to move the information from one column to another how would I get it to reference this column instead.
=IF(A2="SHOES",AC2,IF(A2="Lucky Dip",AC2,(LEFT((MID(AC2,FIND("=",SUBSTITUTE(AC2,"-","=",LEN(AC2)-LEN(SUBSTITUTE(AC2,"-",""))-1))+1,256)),FIND("-",(MID(AC2,FIND("=",SUBSTITUTE(AC2,"-","=",LEN(AC2)-LEN(SUBSTITUTE(AC2,"-",""))-1))+1,256)))-1))))
This sits in B2...the formula in A2 is:
=IFERROR((LOOKUP(9.99E+307,SEARCH('Clothes Categories'!$A$2:$A$179,AC2),'Clothes Categories'!$B$2:$B$179)),"review")
Are these working together to bring resuls?
Thanks
Hoping someone can help me understand the logic in this formula...what cells is it referencing? If I want to move the information from one column to another how would I get it to reference this column instead.
=IF(A2="SHOES",AC2,IF(A2="Lucky Dip",AC2,(LEFT((MID(AC2,FIND("=",SUBSTITUTE(AC2,"-","=",LEN(AC2)-LEN(SUBSTITUTE(AC2,"-",""))-1))+1,256)),FIND("-",(MID(AC2,FIND("=",SUBSTITUTE(AC2,"-","=",LEN(AC2)-LEN(SUBSTITUTE(AC2,"-",""))-1))+1,256)))-1))))
This sits in B2...the formula in A2 is:
=IFERROR((LOOKUP(9.99E+307,SEARCH('Clothes Categories'!$A$2:$A$179,AC2),'Clothes Categories'!$B$2:$B$179)),"review")
Are these working together to bring resuls?
Thanks