Thread: [Solved] Looking for certain words in a string
View Single Post
 
Old 08-07-2019, 12:16 PM
NBVC's Avatar
NBVC NBVC is offline Windows 10 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
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
Reply With Quote