Hi,

Sorry, but with all the other threads I deal with on this forum, and the fact that we're now on post #46 (!) with this one, I think it may well be time that you began a new thread.

I would also suggest that you make your question in that new thread as simple as possible. For example, rather than post your existing formula:

=IF(ISNUMBER(MATCH(PROPER(LEFT(REPLACE(A2,1,FIND("@",A2),""),FIND(".",REPLACE(A2,1,FIND("@",A2),""))-1)),Sheet2!$L$2:$L$15,0)),"",PROPER(LEFT(REPLACE(A2,1,FIND("@",A2),""),FIND(".",REPLACE(A2,1,FIND("@",A2),""))-1)))

and ask for this to be adapted, I think it would be much wiser if you started with a simple example list of e-mail addresses and queried how it woud be possible to make the extraction at the relevant point depending on whether one or more of your search words was found.

Once you have that formula, you'll then be able to either insert it into the above formula, or use it in an extra helper column in your sheet and then combine it with the existing formulas.

Regards