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