Hi,
Does anyone have a vlookup formula or any formula that will help me identify domain names at the end of email addresses?
Example: If one worksheet has multiple emails like "[email protected] , [email protected] , [email protected], etc", what formula can i use to extract or lookup the matching email domains on another worksheet?
Thanks!
You can use this formula to extract domain names from email address
=REPLACE(A1,1,SEARCH("@",A1),"")
[email protected] time.com [email protected] xerox.com
and then do lookup
=VLOOKUP("*"&B1,$C$1:$C$2,1,0)
time.com [email protected] [email protected] xerox.com [email protected] [email protected]
Last edited by AlKey; 06-10-2014 at 01:37 PM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Thanks! It's a perfect solution!
You're welcome and thank you for the feedback!
Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks