Vlook up Error

Options

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:

and here is the ref table:


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