Expanding =IF(ISNUMBER(SEARCH

ArviLaanemets · #6 03-09-2018, 07:27 AM

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.

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