Vlookup on phrase in large block of text

[eaxlns]

I am trying to do a vlookup on a phrase from a block of text to return a value.

For example, on Sheet2, in column A I have

sensory toys

Then on Sheet1 in column A in one cell it says

Mighty Toddler Busy Board for 2 Year Old plus. Sensory Board Buckle Toy with Extra Toddler Learning Activities. Fidget Board, Toddler Travel Toys, Autism Sensory Toys, Busy Boards for Montessori.

all in the same cell then in column B it says LISTING TITLE

I need a formula that would look for the data in Sheet1, in this case sensory toys through all of the data in column A on Sheet1 and then return the value in column B when it finds it.

Secondly, how could I take this formula one step further and return multiple values if sensory toys appeared in more than one cell?

Thanks in advance.

FINDING KEYWORDS.xlsx
	A	B
1	Mighty Toddler Busy Board for 2 Year Old plus. Sensory Board Buckle Toy with Extra Toddler Learning Activities. Fidget Board, Toddler Travel Toys, Autism Sensory Toys, Busy Boards for Montessori.	LISTING TITLE
2	The Toddler Activity Board, With More! While other sensory learning toys stop at belts, laces, snaps and buckles, we kept on going with a sensory play toy that teaches time and date, and fun activities not for any other purpose than as toddler fidget toys! Practice, learn, and play with Mighty Toddler!	BULLETS
3	Skill Board Features: This double-sided, 14x10.5” busy book helps improve 7 basic life skills (button a coat, open and close a snap, zip, buckles and Velcro, latch a bag and tie a lace), have fun (apple game and faces game), and learn with pride (day, month, date, time, season, weather activity).	BULLETS
4	Unique To This Velcro Board: To use zippers, kids need to learn about that annoying little latch! So while our zipper is attached to the board, it separates completely, so kids can learn it. Laces are affixed, to prevent them getting lost, and we included a pocket to store pieces or other things!	BULLETS
5	Is It Easy, Or Hard? Everything is hard the first time, that’s why us parents always say “practice makes perfect” Now imagine the beaming pride on your toddlers face when they turn that hard, into success! Flexible, soft and lightweight with handles, kids can carry it everywhere to maximize practice.	BULLETS
6	For Toddlers, and Kids Ready for Shoe Tying Practice! There are small pieces, so use this busy board for 1 year old or 1-3 years with adult supervision. For 3-4 years or more, use sensible parental discretion. Available in pink or blue sensory boards, choose their favorite color and try it now!	BULLETS
Sheet1

FINDING KEYWORDS.xlsx
	A
1	PHRASE
2	sensory toys
3	sensory toys for toddlers 1-3
4	learning toys for toddlers 1-3
5	busy board
6	autism toys
7	autism sensory toys
8	learning toys
9	toddler learning toys
10	busy board for 1 year old
11	toddler learning
Sheet2

 

[Fluff]

Select the cells you want it to work (for instance A2:C11) then new rule, use a formula & enter the formula. The C2 in the formula must match the first row in the select cells & the column with the values.