find word(a name) within emails list that matches a names table/list

Hi Everyone,

This is my first post. after i was trying to solve this for more than 4 days now, without any success.

Although the solution I seek seems rather straightforward, i'm beginning to wonder if it's even technically possible.

Basically, I have a column of email addresses in worksheet one which I need to check for the presence of names in the emails from all the names listi have listed in another column.

So if any name from the names list is found in email address, i need it to present the name found in the email address.
ex. from email [email protected] i should get the word Cindy next to it.


Factors to be taken into consideration are:
- the names column list may contain up to 10000 keywords (10000 rows)
- the match shouldn't be case sensitive
- the match must be for whole words (and not match "office" to "off")


I have also attached an example of how my data is organized.

Thanks!

=lookup(1e+99,search(b$1:b$5201,left(c2,find("@",c2)-1)),b$1:b$5201)

wow teethless, thats brilliant!!

THNX MAN!!

You're welcome!