Armagoddess
New Member
- Joined
- Feb 7, 2018
- Messages
- 4
Hi, All. I have a long list of keywords that I'd like to return in columns if they match the text in a cell - See below. I'd like to see words returned from List (Column B) in columns C,D,E, etc. if they are found in the corresponding cell in Title (Column A). I've played with a few formulas using ISNUMBER, SEARCH, and LOOKUP without success. Thanks so much!
[TABLE="width: 596"]
<tbody>[TR]
[TD]Title[/TD]
[TD]List[/TD]
[TD]Return A[/TD]
[TD]Return B[/TD]
[TD]Return C[/TD]
[/TR]
[TR]
[TD]Where the Red Fern Grows[/TD]
[TD]lay[/TD]
[TD]fern[/TD]
[TD]red[/TD]
[TD]where[/TD]
[/TR]
[TR]
[TD]Skeleton Crew[/TD]
[TD]fern[/TD]
[TD]skeleton[/TD]
[TD]crew[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]While I Lay Dying[/TD]
[TD]skeleton[/TD]
[TD]lay[/TD]
[TD]dying[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]red[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]crew[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]dying[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]where[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 596"]
<tbody>[TR]
[TD]Title[/TD]
[TD]List[/TD]
[TD]Return A[/TD]
[TD]Return B[/TD]
[TD]Return C[/TD]
[/TR]
[TR]
[TD]Where the Red Fern Grows[/TD]
[TD]lay[/TD]
[TD]fern[/TD]
[TD]red[/TD]
[TD]where[/TD]
[/TR]
[TR]
[TD]Skeleton Crew[/TD]
[TD]fern[/TD]
[TD]skeleton[/TD]
[TD]crew[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]While I Lay Dying[/TD]
[TD]skeleton[/TD]
[TD]lay[/TD]
[TD]dying[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]red[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]crew[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]dying[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]where[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]