Share via

VLookup inconsistent value return

Anonymous
2020-12-19T17:49:57+00:00

using vlookup; the lookup values and the table array values are the same. Only sometimes I get the correct value returned from the column, other times I get #N/A).  I even tried converting all columns to text and/or same number format.  But keep in mind the string of numbers are the same.

=VLOOKUP(D39,'Sheet 1'!$C2:$D6901,2,FALSE)

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

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-12-21T08:49:06+00:00

    Hi Darryl J C,

    I am writing to follow up on this thread.

    May I know if you need further help?

    If so, to narrow down this issue, I would suggest you try to use the VLOOKUP formula in a new Excel file to see the result.

    If the issue doesn’t happen to the new Excel file, I think there may be something wrong with the old file.

    So, I would suggest you try to copy and paste the content form the old file to the new one.

    If the issue also happens to the new file, please kindly refer to this article: How to correct a #N/A error in the VLOOKUP function

    If you need further help, could you please share a sample file for a better understanding? And we will try our best to help you.

    Share OneDrive files and folders - Office Support (microsoft.com)

    Best Regards,

    May

    0 comments
  2. Andreas Killer 144.1K Reputation points Volunteer Moderator
    2020-12-19T18:11:09+00:00

    I'm afraid we have to see your file to recognise where are numbers as text or additional invisible chars.

    Andreas.

    0 comments