ISNUMBER function
If the text in Column A contains certain wording which is contained in a series of options in Column B (Rows B2 to B10, e.g. €śApples and Pears€ť, €śOranges and Lemons€ť etc), then this wording is to be shown on its own in Column C.
Ive made a start:
=IF(ISNUMBER(SEARCH(B2:B10,A2)), C2, "")
Nothing happens
Many thanks.
Kindest regards
|