Looking for certain words in a string

		Microsoft Office Forums > Microsoft Excel > Excel
Looking for certain words in a string

FAQ

Thread Tools

Display Modes

08-07-2019, 12:16 PM

NBVC

Windows 10 Looking for certain words in a string

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to find (highlight) two and more words in a list of 75k single words in Word 2010	Usora	Word	8	05-29-2018 03:34 AM
Wildcard replace any string in context with a specified string	wardw	Word	7	05-07-2018 09:13 AM
How can I compare a string in a cell to another string?	Amitti	Word VBA	2	04-10-2017 07:35 PM
How to find all string within string.	PRA007	Word VBA	18	02-12-2016 08:11 PM
Way to search for a string in text file, pull out everything until another string?	omahadivision	Excel Programming	12	11-23-2013 12:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:10 PM.