The max length of the string is 255.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Steph" wrote in message
...
Hi all. Does anyone know if there are character limitations on
Vlookup or Sumif formulas? I have a file where the cell I am
looking up is quite long. And I seem to recall a while back
that vlookup only reads the first x characters in the lookup
cell. Is this true? Thanks for youe help!