Hello everyone, Trying to reference when there is any word inside of a paragraph listed in cell B1 that matches with any word listed in column A:A.

For Example

B1: President Washington Met with Lincoln to go to the Ulysses's ball

A1 : Washington, George
A2 : Lincoln, Abe
A3 : Ulysses , Grant


Result in Cell C1 : Washington, Lincoln , Ulysses

Had some great help on here already which helped me do this using a Module. Need just a formula without entering into a module if possible. Trying to transfer formula out of excel.