Forum Discussion
Formula Help
HelloDave_Self,
The #NAME? error occurs when Excel can’t recognize part of a formula. Check that the sheet named 41 exists and that it has a named range called Rate. Named ranges are workbook-scoped, so if Rate was only created on sheet 40, referencing '41'!Rate will cause the error. Also make sure the sheet name has no extra spaces or hidden characters. Once the sheet and named range exist correctly, =IF(D66>0,'41'!Rate+$G$18,0) will work. For more information, see Microsoft support articles titled "How to correct a #NAME? error" and "Use the Name Manager in Excel".
Thank you for the reply. The sheets exist. Part of the data on the sheet (WBS) with the non-working formulas has data in columns C and D that are on sheets 41-46. That is what is so puzzling.The data is going from the WBS to sheets 41-46, but it isn't coming back.
It seems to be somehow connected to the "quantity". If you go to items 41-55 and input a quantity, it returns the #NAME? in all of the cells with formulas to the right. Until today, I had not entered more than 40 items so I had no idea there was a problem.
Is there a way to send the workbook so you can see for yourself what I'm trying to describe? I've looked at everything I can think of and am getting nowhere. Sending just the formulas wouldn't do any good without the rest of the workbook to see how they interact.