Search cell for a list of words

[fectly]

Hello. I want to search a cell for a list of words and return the found word.

Example: List A contains the words I want to search for.

List A
Apple
Banana
Orange
Cherry

Cell to Search:
I ate an apple today.

I tried a Search formula but it would only allow me to search one word. I also tried a Lookup formula but it didn't return any of the right words. Thanks in advance!!

 

[hiker95]

fectly,

Welcome to the MrExcel forum.

What version of Excel are you using?


So that we can get it right the first time:

Can you post a screenshot of the raw data worksheet, and, post a screenshot of the worksheet results (manually formatted by you) that you are looking for?

To post your data, you can download and install one of the following two programs:
Excel Jeanie
MrExcel HTML Maker


If you are not able to give us screenshots:
You can upload your workbook to Box Net,
sensitive data scrubbed/removed/changed
mark the workbook for sharing
and provide us with a link to your workbook.