Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 03-09-2018, 07:50 AM
NBVC's Avatar
NBVC NBVC is offline Expanding =IF(ISNUMBER(SEARCH Windows 10 Expanding =IF(ISNUMBER(SEARCH Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

If you use the "Evaluate Formula" tool in the Formulas tab, you can step through to see what's happening.

The Search() part does what you expect and is seaching for any of the B1:B5 entries in A1. The 1/ part converts any entries to values of 1 or less and leaves errors as errors.

The Lookup(2.. part looks for the last time that a value of 2 or less is found in the result array, and it then aligns it to the location with B1:B5 to return the corresponding result.
Reply With Quote
 

Tags
=if, =match, =search



Similar Threads
Thread Thread Starter Forum Replies Last Post
Expanding =IF(ISNUMBER(SEARCH 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
Expanding =IF(ISNUMBER(SEARCH 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 05:44 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft