nesting issue

L

Lost

Hmmm what do I do with this error I am getting? Im using Excel '07 and saved
as marco enabled workbook.

The specified formula cannot be entered because it uses more levels of
nesting than are allowed in the current file format.

I'm using the following formula to look up the amount of an item used by lot
numder across 6 work sheets. I am simply adding the next formula in the false
part of the statement.

=IF(AND(C43='[Stuffing Time Sheet A.xls]sheet5'!$J$5,A43='[Stuffing Time
Sheet A.xls]sheet5'!$B$4),IF(ISERROR(VLOOKUP(R52,'[Stuffing Time Sheet
A.xls]sheet5'!$I$7:$J$17,2,FALSE))," ",(VLOOKUP(R52,'[Stuffing Time Sheet
A.xls]sheet5'!$I$7:$J$17,2,FALSE)))," ")

I need this go across sheet1 thru sheet 6, any ideas?

thank you in advance!!!
 
M

Mike Fogleman

Nested if statements are limited to 7 levels. In order to evaluate more than
that, you would normally use more than one formula and then use a formula
which would evaluate the answers of all the other formulas.

Mike F
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top