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