vlookup uses only first 8 characters of the lookup value?

E

eggman2001

Has anyone else noticed this? VLOOKUP seems to use only the first 8
characters of the lookup value, so both lookup values 12345678 and
123456789 will match a table array value of 12345678. Anyone know of a
way to change this so it uses all characters of the lookup value?
 
P

Peter

Has anyone else noticed this? VLOOKUP seems to use only the first 8
characters of the lookup value, so both lookup values 12345678 and
123456789 will match a table array value of 12345678. Anyone know of a
way to change this so it uses all characters of the lookup value?
Click to expand...

Have you tried to add the ;false in the end of your formula ?

Regards

PEter
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding value using greater than, Vlookup, and nested If 2
Using Parsed String Results in VLOOKUP 2
lookup and return column number 2
A simple vlookup question 7
Match/ Index question 2
help - problem with data using vlookup in Excel 2003 1
Lookup Value 2
Problem with MS Word paragraph and character styles: format getting messed up 2

Top