Share via

VlookUp

Anonymous
2018-09-07T12:20:06+00:00

VLOOKUP Error received - Length Exceeded. This value must be less than or equal to 20 characters.

Trying to do a lookup between two excel files.  Both fields are formatted to Text

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

Answer accepted by question author

Andreas Killer 144.1K Reputation points Volunteer Moderator
2018-09-07T15:05:51+00:00

VLOOKUP is no the cause, see screenshot below.

B2: =VLOOKUP([@[Opportunity Num]],D:E,2,0)

The error message comes from elsewhere.

If you need further help please upload your file (maybe with anonymous data) on an online file hoster like www.dropbox.com and post the download link here.

A macro to anonymize data in selected cells can be downloaded here:

https://www.dropbox.com/s/rkfxuh85j5wyj9y/modAn...

Andreas.

Was this answer helpful?

3 people found this answer helpful.
0 comments

Answer accepted by question author

Anonymous
2018-09-08T12:38:55+00:00

Alex - Thanks for responding.  I figured out my answer.  I converted the Text field to a number and was able to get the function to work as intended.

Brian

Was this answer helpful?

1 person found this answer helpful.
0 comments

4 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-09-10T22:55:10+00:00

    Hi Brian,

    Thanks for sharing the answer with us. If you have any questions about our product, welcome to post in our forum again.

    Regards,

    Alex

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2018-09-07T12:47:08+00:00

    Per your request

    Was this answer helpful?

    0 comments
  3. Vijay A. Verma 104.9K Reputation points Volunteer Moderator
    2018-09-07T12:26:30+00:00
    1. Please post the screenshot of your error message.
    2. Also post your VLOOKUP formula.

    Was this answer helpful?

    0 comments