I am seeking to search through a cell in (B3) for a keyword in a sentence. The keyword should match a word a list in column H (H3:H6). I want the keyword from column H to appear in column F(F3). Any help would be appreciated, thank you in advance. I would post the workbook for reference, but right now the forum isn't allowing me to upload.
B3 cell value
I want green eggs and ham
H3:H6 List
Green
Blue
Red
Black
Bookmarks