Thread
: [Solved]
Looking for certain words in a string
View Single Post
08-07-2019, 12:16 PM
NBVC
Windows 10
Office 2013
The Formula Guy
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
Assuming your list of lookup values is in say J1:J3, then try:
=LOOKUP(2,1/SEARCH($J$1:$J$3,A1),$J$1:$J$3)
where A1 contains first sentence... copied down
NBVC
View Public Profile
Find all posts by NBVC