Looking for certain words in a string

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

FAQ

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 09:13 AM.