What is the maximum amount of carracters that I can use in a look up formula

There's a 1,024 character limit on calculations, with a nested function limit
of 7.
--
Kevin Backmann


"Frances C" wrote:

What is the maximum amount of carracters that I can use in a look up formula

Depends on the version of Excel you're using. In Excel 2007, formulas may
have 8,192 characters nested to 64 levels. In prior versions, it was 1,024
characters nested to 7 levels.

"Frances C" wrote in message
...
What is the maximum amount of carracters that I can use in a look up
formula