Return Missing Values From List

Job ID: 34620444

Budget: $30 – $250 USD

I need an excel formula (not vba) that compares a sentence to a list of words, then returns all words in the sentence not contained in the list of words. Formula should be dynamic. If the list of words is updated, the column of missing values should update as well.

Excel file contains...

List Of Words
-------------
love
hate
pandas
monkeys
-------------

Sentences
-------------
I love pandas
I hate monkeys
pandas pandas pandas
monkeys monkeys
-------------

Expected Results

Sentences - Missing
--------------------------------------------
I love pandas - I
I hate monkeys - I
pandas pandas pandas -
monkeys monkeys -
--------------------------------------------
Related categories: Data Processing Data Entry Excel Excel VBA Excel Macros