{"id":23930,"date":"2021-06-04T11:26:20","date_gmt":"2021-06-04T09:26:20","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=23930"},"modified":"2024-02-06T16:01:23","modified_gmt":"2024-02-06T15:01:23","slug":"name-error-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/name-error-in-excel\/","title":{"rendered":"How to fix the #NAME error in Excel?"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/20.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #NAME error in Excel?\"  class=\"alignnone size-full wp-image-24177\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/20.png\" alt=\"How to fix the #NAME error in Excel?\" width=\"800\" height=\"450\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/20.png 800w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/20-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/20-768x432.png 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/><\/a><\/p>\n<p>#NAME? error occurs when <strong>Excel cannot recognize something<\/strong> in the <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\" title=\"formula\" data-wpil-keyword-link=\"linked\">formula<\/a>. It is a <strong>simple error<\/strong> that arises <strong>due to a spelling mistake<\/strong> in the formula name that you have typed or the <strong>reference provided in the formula doesn&#8217;t exist<\/strong>.<\/p>\n<p>In this article, you will learn the following:<\/p>\n<ul>\n<li><a href=\"#what-is-name-error-in-excel\"><strong>What is #NAME error in Excel?<\/strong><\/a><\/li>\n<li><a href=\"#how-to-fix-null-error-in-excel\"><strong>How to fix #NAME error in Excel?<\/strong><\/a><\/li>\n<li><a href=\"#conclusion\"><strong>Conclusion<\/strong><\/a><\/li>\n<\/ul>\n<p>Follow this<strong> detailed tutorial<\/strong> on #NAME error in Excel and <strong>download this Excel workbook<\/strong> to practice along and\u00a0 understand better:<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Name-error.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\"><strong> download excel workbook<\/strong><\/span><span class=\"postTitle px-3\">Name-error.xlsx<\/span><\/a> <i class=\"fa fa-download\"><\/i><\/p>\n<p>&nbsp;<\/p>\n<\/div>\n<h3><strong><a id=\"what-is-name-error-in-excel\"><\/a><span style=\"color: #339966;\">What is #NAME error in Excel?<\/span><\/strong><\/h3>\n<p>When you are <strong>entering a formula, you might encounter an error<\/strong>, namely the Excel #NAME?. It is due to the fact that while entering the formula there might be a :<\/p>\n<ul>\n<li>Spelling error in<strong> Formula name<\/strong><\/li>\n<li>Spelling error in <strong>Cell Range<\/strong><\/li>\n<li>Spelling error in <strong>Named Range<\/strong><\/li>\n<li>Text entered without quotes<\/li>\n<\/ul>\n<p>It is a simple error to overcome and <strong>can be easily rectified<\/strong>. Let&#8217;s look into this in more detail.<\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966;\"><strong><a id=\"how-to-fix-null-error-in-excel\" style=\"color: #339966;\"><\/a>How to fix #NAME error in Excel?<\/strong><\/span><\/h3>\n<p>In the entirety of the formula, any error in the spelling can lead to this error. Let&#8217;s<strong> learn how to rectify this in different situations<\/strong>.<\/p>\n<p><span style=\"color: #339966;\"><strong>Example 1- Formula name<\/strong><\/span><\/p>\n<p>When entering the<strong> name of the formula if the name is misspelled<\/strong>, then that can lead to the occurrence of this error.<\/p>\n<p>In the above example, you can see that<strong> instead of writing =LEN(A7), we have typed =lan(A7)<\/strong>. There is an error in the formula name, leading to the problem.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image16.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #NAME error in Excel?\"  class=\"alignnone wp-image-23972 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image16.png\" alt=\"How to fix the #NAME error in Excel?\" width=\"690\" height=\"567\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image16.png 690w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image16-300x247.png 300w\" sizes=\"(max-width: 690px) 100vw, 690px\" \/><\/a><\/p>\n<p>Now you can see, <strong>simply correcting the name removes the error displayed<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image17.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #NAME error in Excel?\"  class=\"alignnone size-full wp-image-23976\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image17.png\" alt=\"How to fix the #NAME error in Excel?\" width=\"690\" height=\"568\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image17.png 690w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image17-300x247.png 300w\" sizes=\"(max-width: 690px) 100vw, 690px\" \/><\/a><\/p>\n<p>The <strong>best way to not get #NAME excel error<\/strong>\u00a0is to<strong> choose the formula in the drop-down list while typing<\/strong> the name of the formula. This makes sure that the formula name is not misspelled.<\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #339966;\">Example 2- Cell\/Range name<\/span><\/strong><\/p>\n<p>When entering a<strong> formula that references a certain cell or range<\/strong>, <strong>misspelling the name of the cell or range can lead to this error.<\/strong><\/p>\n<p>Here we can see that the <strong>name of the cell is misspelled<\/strong>. Instead of <strong>=LEN(A7), it is typed as =LEN(AA)<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image23.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #NAME error in Excel?\"  class=\"alignnone size-full wp-image-23975\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image23.png\" alt=\"How to fix the #NAME error in Excel?\" width=\"693\" height=\"570\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image23.png 693w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image23-300x247.png 300w\" sizes=\"(max-width: 693px) 100vw, 693px\" \/><\/a><\/p>\n<p>To rectify this, simply type in the <strong>correct cell name<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image6.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #NAME error in Excel?\"  class=\"alignnone size-full wp-image-23973\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image6.png\" alt=\"How to fix the #NAME error in Excel?\" width=\"689\" height=\"567\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image6.png 689w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image6-300x247.png 300w\" sizes=\"(max-width: 689px) 100vw, 689px\" \/><\/a><\/p>\n<p>A <strong>better way of avoiding<\/strong> the error is to <strong>select the cell when referencing<\/strong> in the formula. This will lead to always entering the correct cell name.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-04-at-7.38.59-PM.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #NAME error in Excel?\"  class=\"alignnone size-full wp-image-23977\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-04-at-7.38.59-PM.png\" alt=\"How to fix the #NAME error in Excel?\" width=\"650\" height=\"551\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-04-at-7.38.59-PM.png 650w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/Screen-Shot-2021-06-04-at-7.38.59-PM-300x254.png 300w\" sizes=\"(max-width: 650px) 100vw, 650px\" \/><\/a><\/p>\n<p>NAME error in Excel<strong>\u00a0can occur when entering a range<\/strong>. Check and correct the range name or select the entire range when entering the formula to rectify the error and prevent it.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966;\"><strong>Example 3- Named range<\/strong><\/span><\/p>\n<p>There can be particularly important<strong> ranges in your workbook that you have assigned a name<\/strong> to. When referencing this range in a formula, <strong>misspelling it can lead to the #NAME error in Excel<\/strong>.<\/p>\n<p>Here we can see that the range referenced to in the <strong>formula is spelled agee when the correct name is Age<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image15.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #NAME error in Excel?\"  class=\"alignnone size-full wp-image-23978\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image15.png\" alt=\"How to fix the #NAME error in Excel?\" width=\"690\" height=\"625\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image15.png 690w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image15-300x272.png 300w\" sizes=\"(max-width: 690px) 100vw, 690px\" \/><\/a><\/p>\n<p><strong>Correcting the name of the range or simply selecting the range<\/strong> when referencing it in the formula will <strong>correct this error<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image28.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #NAME error in Excel?\"  class=\"alignnone size-full wp-image-23979\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image28.png\" alt=\"How to fix the #NAME error in Excel?\" width=\"691\" height=\"632\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image28.png 691w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image28-300x274.png 300w\" sizes=\"(max-width: 691px) 100vw, 691px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966;\"><strong>Example 4- Text without quotes<\/strong><\/span><\/p>\n<p>Wherever a<strong> text is entered into a formula<\/strong>, it should be <strong>entered in quotes<\/strong>. When a <strong>text value is not confined between quotes<\/strong>, <strong>Excel reads it as either a formula or a named range<\/strong>\/table.<\/p>\n<p>If there is <strong>no formula or named range in your workbook that matches the text written<\/strong> in the formula, Excel will <strong>return the #NAME?<\/strong> Error.<\/p>\n<p>Here we can see the <strong>text entered in the formula is not in quotes<\/strong> and hence Excel is returning it as an error.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image9.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #NAME error in Excel?\"  class=\"alignnone wp-image-23980 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image9.png\" alt=\"How to fix the #NAME error in Excel?\" width=\"690\" height=\"568\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image9.png 690w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image9-300x247.png 300w\" sizes=\"(max-width: 690px) 100vw, 690px\" \/><\/a><\/p>\n<p>Now that the <strong>text is written in quotes<\/strong>, Excel is returning the correct value of the formula.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image27.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"How to fix the #NAME error in Excel?\"  class=\"alignnone size-full wp-image-23981\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image27.png\" alt=\"How to fix the #NAME error in Excel?\" width=\"690\" height=\"567\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image27.png 690w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2021\/06\/image27-300x247.png 300w\" sizes=\"(max-width: 690px) 100vw, 690px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><span style=\"color: #339966;\"><strong><a id=\"conclusion\" style=\"color: #339966;\"><\/a>Conclusion<\/strong><\/span><\/h3>\n<p>Now it should be clear that #NAME? Error, as evidenced by its name, is an <strong>error that occurs when there is a spelling error in different components of a formula<\/strong>, be it the name of the formula itself, or the values entered as the formula&#8217;s arguments.<\/p>\n<p>After going through this exercise, we hope that your problems have been solved now.<\/p>\n<p><strong>Click here<\/strong> to learn about the Top 20 Common Errors that you may encounter while working on Excel.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #339966;\"><strong>HELPFUL RESOURCE:<\/strong><\/span><\/p>\n<p>Make sure to download our FREE PDF on the<strong><a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"noopener nofollow\">\u00a0333 Excel keyboard Shortcuts here<\/a>:<\/strong><\/p>\n<p><a href=\"https:\/\/app.monstercampaigns.com\/c\/czseo0viyrmspcx5ndve\/\" target=\"_blank\" rel=\"nofollow noopener\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-14329 size-medium\" title=\"Top 20 Common Excel Problems Solved | MyExcelOnline\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-300x200.jpg\" sizes=\"(max-width: 300px) 100vw, 300px\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-300x200.jpg 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-1024x682.jpg 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups-768x512.jpg 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/03\/333coffeMockups.jpg 1340w\" alt=\"Microsoft Excel Training\" width=\"300\" height=\"200\" \/><\/a><\/p>\n<p>You can learn more about how to use Excel by viewing our FREE Excel webinar training on\u00a0<strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-43.html\" target=\"_blank\" rel=\"noopener noreferrer\">Formulas<\/a>,\u00a0<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-5.html\" target=\"_blank\" rel=\"noopener noreferrer\">Pivot Tables<\/a>,\u00a0<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/power-query-data-cleansing-webinar.html\" target=\"_blank\">Power Query<\/a>,<\/strong>\u00a0and\u00a0<strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/100-39.html\" target=\"_blank\" rel=\"noopener noreferrer\">Macros &amp; VBA<\/a><\/strong>!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>#NAME? error occurs when Excel cannot recognize something in the formula. It is a simple error that arises due to a spelling mistake in the formula name that you have typed or the reference provided in the formula doesn&#8217;t exist. In this article, you will learn the following: What is #NAME error in Excel? How [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":24177,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[6,3],"tags":[728,729],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/23930"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=23930"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/23930\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/24177"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=23930"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=23930"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=23930"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}