Probably 255 characters.

--
Regards,
Tom Ogilvy


"Steph" wrote:

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!