{"id":219420,"date":"2023-12-18T02:31:47","date_gmt":"2023-12-18T02:31:47","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/"},"modified":"2023-12-18T02:31:47","modified_gmt":"2023-12-18T02:31:47","slug":"why-is-vlookup-showing-na-when-value-exists","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/","title":{"rendered":"Why is VLOOKUP showing NA when value exists?"},"content":{"rendered":"<p>If you are using Microsoft Excel or Google Sheets, you might have encountered the frustrating issue of VLOOKUP returning &#8220;NA&#8221; (or #N\/A) when the value you are searching for actually exists in your data. This can be quite perplexing, especially when you have double-checked your data and are confident that the value is present. However, there are several common reasons why this error occurs, and in this article, we will explore them and provide solutions.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_62 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/#1_Why_is_VLOOKUP_showing_NA_when_value_exists\" title=\"1. Why is VLOOKUP showing NA when value exists?\">1. Why is VLOOKUP showing NA when value exists?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/#2_How_can_I_fix_the_issue_when_VLOOKUP_shows_NA\" title=\"2. How can I fix the issue when VLOOKUP shows NA?\">2. How can I fix the issue when VLOOKUP shows NA?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/#3_In_which_situations_does_VLOOKUP_NA_occur_even_when_the_value_exists\" title=\"3. In which situations does VLOOKUP #N\/A occur even when the value exists?\">3. In which situations does VLOOKUP #N\/A occur even when the value exists?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/#4_How_can_I_debug_VLOOKUP_NA_errors\" title=\"4. How can I debug VLOOKUP #N\/A errors?\">4. How can I debug VLOOKUP #N\/A errors?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/#5_Can_VLOOKUP_NA_be_replaced_with_a_blank_cell\" title=\"5. Can VLOOKUP #N\/A be replaced with a blank cell?\">5. Can VLOOKUP #N\/A be replaced with a blank cell?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/#6_Is_there_an_alternative_to_VLOOKUP_that_avoids_NA_errors\" title=\"6. Is there an alternative to VLOOKUP that avoids #N\/A errors?\">6. Is there an alternative to VLOOKUP that avoids #N\/A errors?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/#7_Can_VLOOKUP_return_multiple_values\" title=\"7. Can VLOOKUP return multiple values?\">7. Can VLOOKUP return multiple values?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/#8_How_can_I_make_VLOOKUP_case-sensitive\" title=\"8. How can I make VLOOKUP case-sensitive?\">8. How can I make VLOOKUP case-sensitive?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/#9_How_can_array_formulas_affect_VLOOKUP\" title=\"9. How can array formulas affect VLOOKUP?\">9. How can array formulas affect VLOOKUP?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/#10_Can_conditional_formatting_affect_VLOOKUP\" title=\"10. Can conditional formatting affect VLOOKUP?\">10. Can conditional formatting affect VLOOKUP?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/#11_Can_hidden_columns_affect_VLOOKUP\" title=\"11. Can hidden columns affect VLOOKUP?\">11. Can hidden columns affect VLOOKUP?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/#12_Can_merged_cells_cause_VLOOKUP_issues\" title=\"12. Can merged cells cause VLOOKUP issues?\">12. Can merged cells cause VLOOKUP issues?<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"1_Why_is_VLOOKUP_showing_NA_when_value_exists\"><\/span><strong>1. Why is VLOOKUP showing NA when value exists?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>VLOOKUP returns &#8220;NA&#8221; when it cannot find an exact match for the search value in the lookup range. This typically occurs due to the following reasons:<\/p>\n<p><strong>\u2022 Trailing or leading spaces:<\/strong> The search value might have unnecessary spaces before or after it, causing a mismatch when compared to the data. <\/p>\n<p><\/p>\n<p><strong>\u2022 Different data types:<\/strong> The search value and the values in the lookup range may be of different data types, such as numbers stored as text or vice versa.<\/p>\n<p><\/p>\n<p><strong>\u2022 Case sensitivity:<\/strong> By default, VLOOKUP is not case-sensitive. Therefore, if the case of the search value and the lookup range do not match exactly, VLOOKUP will return &#8220;NA&#8221;.<\/p>\n<p><\/p>\n<p><strong>\u2022 Hidden characters:<\/strong> The search value or the values in the lookup range may contain hidden characters, such as line breaks or non-printable characters.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_How_can_I_fix_the_issue_when_VLOOKUP_shows_NA\"><\/span><strong>2. How can I fix the issue when VLOOKUP shows NA?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>There are several ways to address this problem:<\/p>\n<p><strong>\u2022 Trim the search value:<\/strong> Use the TRIM function to remove any leading or trailing spaces from the search value.<\/p>\n<p><\/p>\n<p><strong>\u2022 Ensure consistent data types:<\/strong> Convert the data types of the search value and the lookup range to match each other. For example, if the search value is a number stored as text, use the VALUE function to convert it to a number.<\/p>\n<p><\/p>\n<p><strong>\u2022 Use case-insensitive lookup:<\/strong> If case sensitivity is not important, convert both the search value and the lookup range to the same case (lowercase or uppercase) using the LOWER or UPPER function.<\/p>\n<p><\/p>\n<p><strong>\u2022 Clean hidden characters:<\/strong> Utilize the CLEAN function to remove any non-printable characters from both the search value and the lookup range.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_In_which_situations_does_VLOOKUP_NA_occur_even_when_the_value_exists\"><\/span><strong>3. In which situations does VLOOKUP #N\/A occur even when the value exists?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>VLOOKUP #N\/A can occur in various situations such as:<\/p>\n<p><\/p>\n<p><strong>\u2022 Lookup range limitations:<\/strong> If the search value falls outside the defined lookup range, VLOOKUP will return #N\/A. Ensure that the lookup range covers the entire dataset.<\/p>\n<p><\/p>\n<p><strong>\u2022 Sorted data:<\/strong> VLOOKUP requires the data to be sorted in ascending order for approximate match searches (when using &#8220;TRUE&#8221; or &#8220;1&#8221; as the fourth argument). If the data is not sorted correctly, it can result in #N\/A errors.<\/p>\n<p><\/p>\n<p><strong>\u2022 Missing or mismatched data:<\/strong> If the lookup range contains blank cells or if there is a mismatch between the column index number and the number of columns in the lookup range, VLOOKUP may return #N\/A.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_How_can_I_debug_VLOOKUP_NA_errors\"><\/span><strong>4. How can I debug VLOOKUP #N\/A errors?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>You can follow these steps to troubleshoot and debug VLOOKUP #N\/A errors:<\/p>\n<p><\/p>\n<p><strong>\u2022 Double-check the lookup range:<\/strong> Confirm that the search value and the lookup range cover the same range.<\/p>\n<p><\/p>\n<p><strong>\u2022 Verify the data types:<\/strong> Ensure that the search value and the values in the lookup range are of the same data type.<\/p>\n<p><\/p>\n<p><strong>\u2022 Check for hidden characters:<\/strong> Examine whether there are any non-visible characters present in the search value or the lookup range that might cause a mismatch.<\/p>\n<p><\/p>\n<p><strong>\u2022 Ensure proper sorting:<\/strong> If using approximate match searches, confirm that the lookup range is sorted in ascending order based on the column being searched.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"5_Can_VLOOKUP_NA_be_replaced_with_a_blank_cell\"><\/span><strong>5. Can VLOOKUP #N\/A be replaced with a blank cell?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>Yes, you can replace the VLOOKUP #N\/A error with a blank cell or any other desired value using the IFERROR function. For example:<\/p>\n<p><\/p>\n<p>=IFERROR(VLOOKUP(search_value, lookup_range, column_index, FALSE),&#8221;&#8221;)<\/p>\n<p><\/p>\n<p>This formula will return a blank cell when VLOOKUP encounters an #N\/A error.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"6_Is_there_an_alternative_to_VLOOKUP_that_avoids_NA_errors\"><\/span><strong>6. Is there an alternative to VLOOKUP that avoids #N\/A errors?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>Yes, the INDEX-MATCH formula is an alternative to VLOOKUP that can avoid #N\/A errors. It offers more flexibility in terms of searching and allows you to handle non-exact matches more effectively.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"7_Can_VLOOKUP_return_multiple_values\"><\/span><strong>7. Can VLOOKUP return multiple values?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>No, VLOOKUP only returns the first match it encounters. If you need to retrieve multiple values, you will need to use alternative formulas like INDEX-MATCH or combination formulas like VLOOKUP with FILTER or ARRAYFORMULA.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"8_How_can_I_make_VLOOKUP_case-sensitive\"><\/span><strong>8. How can I make VLOOKUP case-sensitive?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>To make VLOOKUP case-sensitive, you must use an array formula with the EXACT function. This compares each value in the lookup range with the search value, taking case into consideration.<\/p>\n<p><\/p>\n<p>For example: {=INDEX(return_range, MATCH(TRUE, EXACT(lookup_value, lookup_range), 0))}<\/p>\n<h3><span class=\"ez-toc-section\" id=\"9_How_can_array_formulas_affect_VLOOKUP\"><\/span><strong>9. How can array formulas affect VLOOKUP?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>If you use VLOOKUP within an array formula, it can alter the behavior of the lookup function. In some cases, it can lead to incorrect matches or unexpected results.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"10_Can_conditional_formatting_affect_VLOOKUP\"><\/span><strong>10. Can conditional formatting affect VLOOKUP?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>No, conditional formatting does not affect VLOOKUP. It purely changes the appearance of cells based on specified criteria.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"11_Can_hidden_columns_affect_VLOOKUP\"><\/span><strong>11. Can hidden columns affect VLOOKUP?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>No, VLOOKUP can work even with hidden columns. Hidden columns do not impact the lookup process as long as the search value and the relevant columns are visible.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"12_Can_merged_cells_cause_VLOOKUP_issues\"><\/span><strong>12. Can merged cells cause VLOOKUP issues?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>Merged cells can indeed cause issues with VLOOKUP. If the lookup range contains merged cells, ensure that the search value and the merged cells are aligned correctly. Using unmerged cells is best to avoid any potential problems with VLOOKUP.<\/p>\n<p>By understanding the common reasons behind VLOOKUP returning &#8220;NA&#8221; when the value exists and implementing the appropriate solutions, you can overcome this issue and confidently utilize this powerful Excel or Google Sheets function.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you are using Microsoft Excel or Google Sheets, you might have encountered the frustrating issue of VLOOKUP returning &#8220;NA&#8221; (or #N\/A) when the value you are searching for actually exists in your data. This can be quite perplexing, especially when you have double-checked your data and are confident that the value is present. However, &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"Why is VLOOKUP showing NA when value exists?\" class=\"read-more button\" href=\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/#more-219420\">Read more<span class=\"screen-reader-text\">Why is VLOOKUP showing NA when value exists?<\/span><\/a><\/p>\n","protected":false},"author":55,"featured_media":107420,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[86279],"tags":[],"class_list":["post-219420","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-learn","no-featured-image-padding"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Why is VLOOKUP showing NA when value exists?<\/title>\n<meta name=\"description\" content=\"If you are using Microsoft Excel or Google Sheets, you might have encountered the frustrating issue of VLOOKUP returning &quot;NA&quot; (or #N\/A) when the value you\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Why is VLOOKUP showing NA when value exists?\" \/>\n<meta property=\"og:description\" content=\"If you are using Microsoft Excel or Google Sheets, you might have encountered the frustrating issue of VLOOKUP returning &quot;NA&quot; (or #N\/A) when the value you\" \/>\n<meta property=\"og:url\" content=\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/\" \/>\n<meta property=\"og:site_name\" content=\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/synchronyfinancial\" \/>\n<meta property=\"article:published_time\" content=\"2023-12-18T02:31:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\" \/>\n\t<meta property=\"og:image:width\" content=\"500\" \/>\n\t<meta property=\"og:image:height\" content=\"164\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Darla Clarke\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@synchrony\" \/>\n<meta name=\"twitter:site\" content=\"@synchrony\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Darla Clarke\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/\"},\"author\":{\"name\":\"Darla Clarke\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/8fb46297981687fe77339d265491391e\"},\"headline\":\"Why is VLOOKUP showing NA when value exists?\",\"datePublished\":\"2023-12-18T02:31:47+00:00\",\"dateModified\":\"2023-12-18T02:31:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/\"},\"wordCount\":940,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"articleSection\":[\"Learn\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/\",\"name\":\"Why is VLOOKUP showing NA when value exists?\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\"},\"datePublished\":\"2023-12-18T02:31:47+00:00\",\"dateModified\":\"2023-12-18T02:31:47+00:00\",\"description\":\"If you are using Microsoft Excel or Google Sheets, you might have encountered the frustrating issue of VLOOKUP returning \\\"NA\\\" (or #N\/A) when the value you\",\"breadcrumb\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/namso-gen.co\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Why is VLOOKUP showing NA when value exists?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"description\":\"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co\",\"publisher\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/namso-gen.co\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#organization\",\"name\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\",\"url\":\"https:\/\/namso-gen.co\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"contentUrl\":\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png\",\"width\":500,\"height\":164,\"caption\":\"Namso Gen Blog - Free Credit Card Generator [100% Valid]\"},\"image\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/synchronyfinancial\",\"https:\/\/twitter.com\/synchrony\",\"https:\/\/www.youtube.com\/synchronyfinancial\",\"https:\/\/www.instagram.com\/synchrony\",\"https:\/\/www.linkedin.com\/company\/synchrony-financial\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/8fb46297981687fe77339d265491391e\",\"name\":\"Darla Clarke\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g\",\"caption\":\"Darla Clarke\"},\"description\":\"Guest author Darla Clarke has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Why is VLOOKUP showing NA when value exists?","description":"If you are using Microsoft Excel or Google Sheets, you might have encountered the frustrating issue of VLOOKUP returning \"NA\" (or #N\/A) when the value you","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/","og_locale":"en_US","og_type":"article","og_title":"Why is VLOOKUP showing NA when value exists?","og_description":"If you are using Microsoft Excel or Google Sheets, you might have encountered the frustrating issue of VLOOKUP returning \"NA\" (or #N\/A) when the value you","og_url":"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/","og_site_name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","article_publisher":"https:\/\/www.facebook.com\/synchronyfinancial","article_published_time":"2023-12-18T02:31:47+00:00","og_image":[{"width":500,"height":164,"url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","type":"image\/png"}],"author":"Darla Clarke","twitter_card":"summary_large_image","twitter_creator":"@synchrony","twitter_site":"@synchrony","twitter_misc":{"Written by":"Darla Clarke","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/#article","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/"},"author":{"name":"Darla Clarke","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/8fb46297981687fe77339d265491391e"},"headline":"Why is VLOOKUP showing NA when value exists?","datePublished":"2023-12-18T02:31:47+00:00","dateModified":"2023-12-18T02:31:47+00:00","mainEntityOfPage":{"@id":"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/"},"wordCount":940,"commentCount":0,"publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"articleSection":["Learn"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/","url":"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/","name":"Why is VLOOKUP showing NA when value exists?","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/#website"},"datePublished":"2023-12-18T02:31:47+00:00","dateModified":"2023-12-18T02:31:47+00:00","description":"If you are using Microsoft Excel or Google Sheets, you might have encountered the frustrating issue of VLOOKUP returning \"NA\" (or #N\/A) when the value you","breadcrumb":{"@id":"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/namso-gen.co\/blog\/why-is-vlookup-showing-na-when-value-exists\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/namso-gen.co\/blog\/"},{"@type":"ListItem","position":2,"name":"Why is VLOOKUP showing NA when value exists?"}]},{"@type":"WebSite","@id":"https:\/\/namso-gen.co\/blog\/#website","url":"https:\/\/namso-gen.co\/blog\/","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","description":"In Namso gen blog you can get many tips regarding to Credit cards, VCC, Credit card security etc. You can generate credit cards by using Namso-gen.co","publisher":{"@id":"https:\/\/namso-gen.co\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/namso-gen.co\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/namso-gen.co\/blog\/#organization","name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","url":"https:\/\/namso-gen.co\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","contentUrl":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2020\/07\/namso-gen-logo.png","width":500,"height":164,"caption":"Namso Gen Blog - Free Credit Card Generator [100% Valid]"},"image":{"@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/synchronyfinancial","https:\/\/twitter.com\/synchrony","https:\/\/www.youtube.com\/synchronyfinancial","https:\/\/www.instagram.com\/synchrony","https:\/\/www.linkedin.com\/company\/synchrony-financial"]},{"@type":"Person","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/8fb46297981687fe77339d265491391e","name":"Darla Clarke","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/?s=96&d=mm&r=g","caption":"Darla Clarke"},"description":"Guest author Darla Clarke has meticulously crafted and revised this article to the best of their knowledge and understanding. Readers are strongly advised to exercise caution, verify information independently, and rely on their own judgment when considering the information provided. Read more articles on Namso Gen here."}]}},"_links":{"self":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/219420","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/users\/55"}],"replies":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/comments?post=219420"}],"version-history":[{"count":0,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/219420\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media\/107420"}],"wp:attachment":[{"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/media?parent=219420"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/categories?post=219420"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/tags?post=219420"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}