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? Also posting this in
program forum also.
thank you in advance!!!
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? Also posting this in
program forum also.
thank you in advance!!!