Vlook up Error

Hello Everyone

I am using vlookup to return a contact card based on an email but for some reason, it keeps showing me #No Match even tho the email is found. Here is the formula for the Vlookup:

Screen Shot 2021-07-23 at 6.14.20 AM.png

and here is the ref table:

Screen Shot 2021-07-23 at 6.14.59 AM.png


I am using this formula in a different sheet and it works fine but it doesn't look at the email so i don't know if that is what is causing it. I am getting the email with a "Create By" column so i don't know if that its cause the issues.


Any help is welcome :) thanks!

Tags:

Answers