Posted to microsoft.public.excel.programming

external usenet poster

Posts: 2

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
ISNUMBER Function	Jon	Excel Discussion (Misc queries)	2	January 14th 09 04:31 PM
Isnumber function - question about data type	[email protected]	Excel Programming	2	November 29th 06 02:21 PM
IsNumber & Mid function	El Bee	Excel Worksheet Functions	3	March 3rd 06 09:05 PM
Getting a Function not defined in VBA editor for IsNumber()	Dennis	Excel Discussion (Misc queries)	2	March 2nd 06 01:28 AM
isnumber()	mark kubicki	Excel Programming	2	November 5th 04 04:25 AM

All times are GMT +1. The time now is 09:55 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us