What is the maximum amount of carracters that I can use in a look up formula
F Frances C Sep 28, 2007 #1 What is the maximum amount of carracters that I can use in a look up formula
K Kevin B Sep 28, 2007 #2 There's a 1,024 character limit on calculations, with a nested function limit of 7.
W Wondering Sep 29, 2007 #3 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.
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.
