Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-09-2018, 07:27 AM
ArviLaanemets ArviLaanemets is offline Expanding =IF(ISNUMBER(SEARCH Windows 8 Expanding =IF(ISNUMBER(SEARCH Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

Create a function (you have to change from *.xlsx to *.xlsm)
Code:
Public Function FoundInRange(parRange As Range, parValue As Variant) As Boolean
 
    Dim intRows As Integer
    intRows = parRange.Rows.Count
 
    Dim IsFound As Boolean
    Dim i As Integer
    IsFound = False
 
    For i = 1 To intRows
        If InStr(parRange(i), CStr(parValue)) > 0 Then
            IsFound = True
            Exit For
        End If
    Next i
 
    FoundInRange = IsFound
End Function
Now, into your table p.e. on row 2 enter the formula like


Code:
=FoundInRange($A$2:$A$6,B2)
, and copy it down.
Reply With Quote
Reply

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 07:29 AM.


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