Hi,
My head is a bit pickled, I am trying to run an If formula but not getting it right. Can you help?
I need to be able to get the below two formulas to work together for both Beanie and Blanket:
=IF(S2="123",IF(ISNUMBER(SEARCH({"beanie","hat"},R2)),"Beanie"),IF(S2="456","Ignore"))...