Thread
:
match some character in b1 to c1 and display on d1
View Single Post
#
5
Spencer101
Senior Member
Posts: 663
Quote:
Originally Posted by
clay8
I am trying to match a any possible combination ,
eg
clariceLeonielee @abc.com
clarice_Leonie_lee @abc.com
etc
the main purpose is to check if the email is correctly tied to the name but some poeple have common / similar name.
Any other suggestions?
opps forget to say thanks!
Thanks!
If you have a list of names and which email should be associated with that name you could create a VLOOKUP comparison. That would do the trick (if I've understood what you're trying to achieve of course).
Reply With Quote
Spencer101
View Public Profile
Send a private message to Spencer101
Find all posts by Spencer101