Formula too big at 1,024 characters

[Portuga]

It seems excel formulas are limited to 1024 characters.

For the first time in my life I saw this error message.

Any way to increase this limit?

[NBVC]

Only by upgrading to 2007... where you have 8000+ chars allowed.

[VBA Noob]

Maybe you should look at shortening the formula ??

VBA Noob

[Portuga]

I cant see a way considering the formula. I got a work around for it by spliting the formula in 2 and using 2 cells.

This formula is concatenating the results of 12 Vlookup formulas from 12 different worksheets.

See the thread

http://www.excelforum.com/showthread...=636991&page=2

[VBA Noob]

I see what you mean now.

You may be able to save a few characters by using the ISNA instead of ISERROR. Also if the OP changed the sheet names from whole months to first three characters.

VBA Noob

[NBVC]

I cant see a way considering the formula. I got a work around for it by spliting the formula in 2 and using 2 cells.

This formula is concatenating the results of 12 Vlookup formulas from 12 different worksheets.

See the thread

http://www.excelforum.com/showthread...=636991&page=2

If the OP downloads and installs the free Morefunc.xll addin from this site: http://xcell05.free.fr/english/

Then they could use:

Please Login or Register  to view this content.

The THREED function creates an array joining all ranges in all sheets.

To avoid the #N/A error:

Please Login or Register  to view this content.

[Portuga]

Hi,

Shg posted a good solution in the OP thread. Adding the IFERRORS function using VB code (IFERRORS function is available on excel2007), its possible to cut down the number of characters needed to 590.

Thanks for the input guys!