Expanding =IF(ISNUMBER(SEARCH

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

FAQ

Thread Tools

Display Modes

03-09-2018, 07:27 AM

sru

Windows 10 Expanding =IF(ISNUMBER(SEARCH

Office 2016

Novice

Join Date: Mar 2018

Posts: 3

Thanks

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.

Brilliant, this worked perfectly.

Any chance you can break it down so I know why it worked ha

Thanks very much for the help!

Tags

=if, =match, =search

« Previous Thread | Next Thread »

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 10:50 PM.