Find which ones are school shoes

[makinmomb]

I have this on a1 and a2

BOY OPEN SANDALS,LEATHER,BKSTRAP Brown 30
BOY SCHOOL SHOE, LEATHER,LACES Black 41

I want on b1 and b2 as follows

NOT SCHOOL
YES SCHOOL

YES SCHOOL because there is the word school somewhere on the second description

[samba_ravi]

b1=IF(COUNTIF(A1,"*School*"),"Yes School","Not School")

Please Login or Register  to view this content.

[makinmomb]

Yes thank you