Vlookup Limitations

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!

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!
>
>
>

The max length of the string is 255.


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


"Steph" <[email protected]> wrote in message
news:[email protected]...
> 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!
>
>