Different Types of Errors in Excel and how to Troubleshoot Errors (#DIV/0!, #NAME?, #N/A, #NUM!, #VALUE!, #REF!, #NULL!, #SPILL!, #CALC!, #BUSY & ###)The #NAME error in Excel occurs when you incorrectly type the range name, refer to a deleted range name, or forget to put quotation marks around a textAre you getting the #NAME?
How To Correct A Name Error In Excel