nesting issues

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

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