vlookup uses only first 8 characters of the lookup value?

  • Thread starter Thread starter eggman2001
  • Start date Start date
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?
 
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
 
Back
Top