View Single Post
  #1   Report Post  
Old February 11th 20, 02:10 AM posted to microsoft.public.excel.programming
PaddyStan PaddyStan is offline
external usenet poster
First recorded activity by ExcelBanter: Feb 2020
Posts: 2
Default 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.

I’ve made a start:

=IF(ISNUMBER(SEARCH(B2:B10,A2)), C2, "")

Nothing happens

Many thanks.

Kindest regards