nesting issue

[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!!!

 

[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