![]() |
|
#1
|
|||
|
|||
![]()
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 Code:
=FoundInRange($A$2:$A$6,B2) |
![]() |
Tags |
=if, =match, =search |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
Dkline | Excel | 3 | 06-04-2014 06:40 AM |
How to prevent Tables from expanding | HappyFingers | Word | 1 | 11-29-2010 01:54 PM |