Vlook up Error

Adrian Rosario Perez

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!

Andrée Starå

Hi @Adrian Rosario Perez

It looks like it doesn't match because it's not the same format.

I'd be happy to take a quick look.

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Adrian Rosario Perez

Hey @Andrée Starå

I share the sheet that thanks for the help :)