how can i match e-mails that are the same in different sheets but have different names, for example
sheet 1, e-mail stated John Do, [email protected]
sheet 2, e-mail states Do John, [email protected]
Even though the e-mail address is the same I can not find them using vlookup, I get a No match error, this is caused by the fact that the names do not match. I don't understand why the name is taken in consideration for the match, I'm looking for the e-mail address not the name.
Does anyone have an idear how to solve this. I have got a lot of sheets with reports that are based on e-mail data and as such my results are not reflecting the reality because the e-mails don't match.
Thanks for your idears.
Help Article Resources
Check out the Formula Handbook template!