Share via

vlookup error #N/A

Anonymous
2024-07-29T19:15:39+00:00

vlookup error #N/A

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-07-30T05:54:40+00:00

    Hi schurbert,

    Welcome to Microsoft Community. #N/A occurs when either the value you’re trying to find doesn’t exist, or it does exist—but Excel doesn’t perceive it as a match because of a formatting mismatch or other issue.

    Common reason may be invisible blank spaces in the cell.

    If it is possible, you can share a sample workbook with us by private message.

    Best Regards,

    Thomas.L - MSFT | Microsoft Community Support Specialist

    Was this answer helpful?

    0 comments