Expanding =IF(ISNUMBER(SEARCH

		Microsoft Office Forums > Microsoft Excel > Excel
Expanding =IF(ISNUMBER(SEARCH

FAQ

Mark Forums Read

Thread Tools

Display Modes

03-09-2018, 06:59 AM

NBVC

Windows 10 Expanding =IF(ISNUMBER(SEARCH

Office 2013

The Formula Guy

Join Date: Mar 2012

Location: Mississauga, CANADA

Posts: 215

Try:

=IFERROR(LOOKUP(2,1/SEARCH($B$1:$B$5,A1),$B$1:$B$5),"No")

copied down after adjusting range to suit. Don't use whole columns, use only range containing data.

Tags

=if, =match, =search

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
ISNUMBER formula not working	bishweshwar	Excel	3	03-13-2017 10:07 AM
Expanding a formula bug on Mac's Excel	Bouss	Excel	0	01-27-2017 06:22 PM
Prevent cell from expanding vertically.	snowboarder2	Word Tables	1	08-24-2016 02:52 PM
IF, ISNUMBER & AND function	Dkline	Excel	3	06-04-2014 06:40 AM
How to prevent Tables from expanding	HappyFingers	Word	1	11-29-2010 01:54 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:08 AM.