| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ISNUMBER Function | Excel Discussion (Misc queries) | |||
| Isnumber function - question about data type | Excel Programming | |||
| IsNumber & Mid function | Excel Worksheet Functions | |||
| Getting a Function not defined in VBA editor for IsNumber() | Excel Discussion (Misc queries) | |||
| isnumber() | Excel Programming | |||
Threaded Mode
