{"id":219404,"date":"2023-12-25T16:02:42","date_gmt":"2023-12-25T16:02:42","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/why-is-vlookup-returning-0-when-there-is-a-value\/"},"modified":"2023-12-25T16:02:42","modified_gmt":"2023-12-25T16:02:42","slug":"why-is-vlookup-returning-0-when-there-is-a-value","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/why-is-vlookup-returning-0-when-there-is-a-value\/","title":{"rendered":"Why is VLOOKUP returning 0 when there is a value?"},"content":{"rendered":"<p>**Why is VLOOKUP returning 0 when there is a value?**<\/p>\n<p>VLOOKUP is a powerful function in Microsoft Excel that allows you to search for a specific value in a column and retrieve a corresponding value from another column. However, there may be instances where the VLOOKUP formula returns 0 even though there is a value that matches the lookup criteria. This can be frustrating for users who rely on accurate data retrieval. Let&#8217;s explore some possible reasons why VLOOKUP may return 0 in these cases and how you can resolve them.<\/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-returning-0-when-there-is-a-value\/#1_Is_the_lookup_column_sorted_in_ascending_order\" title=\"1. Is the lookup column sorted in ascending order?\">1. Is the lookup column sorted in ascending order?<\/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-returning-0-when-there-is-a-value\/#2_Are_you_using_an_exact_match\" title=\"2. Are you using an exact match?\">2. Are you using an exact match?<\/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-returning-0-when-there-is-a-value\/#3_Have_you_accidentally_omitted_the_range_lookup_argument\" title=\"3. Have you accidentally omitted the range_lookup argument?\">3. Have you accidentally omitted the range_lookup argument?<\/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-returning-0-when-there-is-a-value\/#4_Did_you_check_for_leading_or_trailing_spaces\" title=\"4. Did you check for leading or trailing spaces?\">4. Did you check for leading or trailing spaces?<\/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-returning-0-when-there-is-a-value\/#5_Is_the_lookup_value_in_the_correct_format\" title=\"5. Is the lookup value in the correct format?\">5. Is the lookup value in the correct format?<\/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-returning-0-when-there-is-a-value\/#6_Does_the_lookup_value_include_special_characters\" title=\"6. Does the lookup value include special characters?\">6. Does the lookup value include special characters?<\/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-returning-0-when-there-is-a-value\/#7_Is_the_lookup_value_a_formula_or_a_result_of_another_formula\" title=\"7. Is the lookup value a formula or a result of another formula?\">7. Is the lookup value a formula or a result of another formula?<\/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-returning-0-when-there-is-a-value\/#8_Is_the_lookup_column_in_the_correct_data_type\" title=\"8. Is the lookup column in the correct data type?\">8. Is the lookup column in the correct data type?<\/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-returning-0-when-there-is-a-value\/#9_Are_there_any_hidden_characters_or_non-printable_characters\" title=\"9. Are there any hidden characters or non-printable characters?\">9. Are there any hidden characters or non-printable characters?<\/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-returning-0-when-there-is-a-value\/#10_Is_your_formula_referencing_the_correct_cells\" title=\"10. Is your formula referencing the correct cells?\">10. Is your formula referencing the correct cells?<\/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-returning-0-when-there-is-a-value\/#11_Have_you_updated_the_formula_after_inserting_rows_or_columns\" title=\"11. Have you updated the formula after inserting rows or columns?\">11. Have you updated the formula after inserting rows or columns?<\/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-returning-0-when-there-is-a-value\/#12_Could_the_value_be_stored_as_text\" title=\"12. Could the value be stored as text?\">12. Could the value be stored as text?<\/a><\/li><\/ul><\/nav><\/div>\n<h3><span class=\"ez-toc-section\" id=\"1_Is_the_lookup_column_sorted_in_ascending_order\"><\/span>1. Is the lookup column sorted in ascending order?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nVLOOKUP requires the lookup column to be sorted in ascending order. If the column is not sorted, the function may return incorrect results, including 0.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Are_you_using_an_exact_match\"><\/span>2. Are you using an exact match?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nBy default, VLOOKUP performs an approximate match, meaning it will return the next smallest value if an exact match is not found. To ensure an exact match, you should specify &#8220;FALSE&#8221; as the last argument in your formula.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_Have_you_accidentally_omitted_the_range_lookup_argument\"><\/span>3. Have you accidentally omitted the range_lookup argument?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThe range_lookup argument indicates whether you want an approximate match or an exact match. If you omit this argument, Excel assumes that you want an approximate match, which can result in incorrect results.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_Did_you_check_for_leading_or_trailing_spaces\"><\/span>4. Did you check for leading or trailing spaces?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThe lookup value or the values in the lookup column might contain leading or trailing spaces, which can cause a mismatch. Using the TRIM function can help remove any extra spaces for accurate lookup.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"5_Is_the_lookup_value_in_the_correct_format\"><\/span>5. Is the lookup value in the correct format?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nEnsure that your lookup value is in the correct format. VLOOKUP relies on the data types of the lookup value and the values in the lookup column to perform the match accurately.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"6_Does_the_lookup_value_include_special_characters\"><\/span>6. Does the lookup value include special characters?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nSpecial characters, such as ampersands or asterisks, can interfere with the VLOOKUP functionality. Try removing any special characters from the lookup value and the lookup column.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"7_Is_the_lookup_value_a_formula_or_a_result_of_another_formula\"><\/span>7. Is the lookup value a formula or a result of another formula?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nIf the lookup value is derived from a formula, it may not exactly match the values in the lookup column due to rounding errors or formatting. Check that the formula is returning the expected result.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"8_Is_the_lookup_column_in_the_correct_data_type\"><\/span>8. Is the lookup column in the correct data type?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nEnsure that the lookup column is in the same data type as the lookup value. For example, if you are looking up a numeric value, make sure the lookup column contains numbers and not text.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"9_Are_there_any_hidden_characters_or_non-printable_characters\"><\/span>9. Are there any hidden characters or non-printable characters?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nHidden characters or non-printable characters can cause VLOOKUP to return 0 instead of the desired value. Use the CLEAN function to remove any non-printable characters from the lookup column and the lookup value.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"10_Is_your_formula_referencing_the_correct_cells\"><\/span>10. Is your formula referencing the correct cells?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nVerify that your VLOOKUP formula references the correct cells. Mistakenly selecting the wrong cells can result in unexpected results, including 0.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"11_Have_you_updated_the_formula_after_inserting_rows_or_columns\"><\/span>11. Have you updated the formula after inserting rows or columns?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nIf you have inserted or deleted rows or columns after creating the VLOOKUP formula, it may no longer reference the correct range. Make sure to update the formula to include the appropriate cells.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"12_Could_the_value_be_stored_as_text\"><\/span>12. Could the value be stored as text?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nIf the lookup value or the values in the lookup column are stored as text, while you are expecting them to be numbers, the VLOOKUP function may return 0. You can use the VALUE function to convert the text to numbers for accurate matching.<\/p>\n<p>**In conclusion, VLOOKUP may return 0 when there is a value due to multiple factors such as unsorted data, incorrect match type, leading or trailing spaces, incorrect formatting, special characters, formula discrepancies, data type mismatches, hidden characters, incorrect cell references, or data manipulation. By addressing these potential issues, you can ensure that the VLOOKUP function returns the accurate results you need for effective data retrieval in Excel.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>**Why is VLOOKUP returning 0 when there is a value?** VLOOKUP is a powerful function in Microsoft Excel that allows you to search for a specific value in a column and retrieve a corresponding value from another column. However, there may be instances where the VLOOKUP formula returns 0 even though there is a value &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"Why is VLOOKUP returning 0 when there is a value?\" class=\"read-more button\" href=\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-returning-0-when-there-is-a-value\/#more-219404\">Read more<span class=\"screen-reader-text\">Why is VLOOKUP returning 0 when there is a value?<\/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-219404","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 returning 0 when there is a value?<\/title>\n<meta name=\"description\" content=\"**Why is VLOOKUP returning 0 when there is a value?** VLOOKUP is a powerful function in Microsoft Excel that allows you to search for a specific value in\" \/>\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-returning-0-when-there-is-a-value\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Why is VLOOKUP returning 0 when there is a value?\" \/>\n<meta property=\"og:description\" content=\"**Why is VLOOKUP returning 0 when there is a value?** VLOOKUP is a powerful function in Microsoft Excel that allows you to search for a specific value in\" \/>\n<meta property=\"og:url\" content=\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-returning-0-when-there-is-a-value\/\" \/>\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-25T16:02:42+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=\"3 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-returning-0-when-there-is-a-value\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-returning-0-when-there-is-a-value\/\"},\"author\":{\"name\":\"Darla Clarke\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/8fb46297981687fe77339d265491391e\"},\"headline\":\"Why is VLOOKUP returning 0 when there is a value?\",\"datePublished\":\"2023-12-25T16:02:42+00:00\",\"dateModified\":\"2023-12-25T16:02:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-returning-0-when-there-is-a-value\/\"},\"wordCount\":647,\"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-returning-0-when-there-is-a-value\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-returning-0-when-there-is-a-value\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-returning-0-when-there-is-a-value\/\",\"name\":\"Why is VLOOKUP returning 0 when there is a value?\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\"},\"datePublished\":\"2023-12-25T16:02:42+00:00\",\"dateModified\":\"2023-12-25T16:02:42+00:00\",\"description\":\"**Why is VLOOKUP returning 0 when there is a value?** VLOOKUP is a powerful function in Microsoft Excel that allows you to search for a specific value in\",\"breadcrumb\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-returning-0-when-there-is-a-value\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-returning-0-when-there-is-a-value\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/namso-gen.co\/blog\/why-is-vlookup-returning-0-when-there-is-a-value\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/namso-gen.co\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Why is VLOOKUP returning 0 when there is a value?\"}]},{\"@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 returning 0 when there is a value?","description":"**Why is VLOOKUP returning 0 when there is a value?** VLOOKUP is a powerful function in Microsoft Excel that allows you to search for a specific value in","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-returning-0-when-there-is-a-value\/","og_locale":"en_US","og_type":"article","og_title":"Why is VLOOKUP returning 0 when there is a value?","og_description":"**Why is VLOOKUP returning 0 when there is a value?** VLOOKUP is a powerful function in Microsoft Excel that allows you to search for a specific value in","og_url":"https:\/\/namso-gen.co\/blog\/why-is-vlookup-returning-0-when-there-is-a-value\/","og_site_name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","article_publisher":"https:\/\/www.facebook.com\/synchronyfinancial","article_published_time":"2023-12-25T16:02:42+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":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/namso-gen.co\/blog\/why-is-vlookup-returning-0-when-there-is-a-value\/#article","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/why-is-vlookup-returning-0-when-there-is-a-value\/"},"author":{"name":"Darla Clarke","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/8fb46297981687fe77339d265491391e"},"headline":"Why is VLOOKUP returning 0 when there is a value?","datePublished":"2023-12-25T16:02:42+00:00","dateModified":"2023-12-25T16:02:42+00:00","mainEntityOfPage":{"@id":"https:\/\/namso-gen.co\/blog\/why-is-vlookup-returning-0-when-there-is-a-value\/"},"wordCount":647,"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-returning-0-when-there-is-a-value\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/namso-gen.co\/blog\/why-is-vlookup-returning-0-when-there-is-a-value\/","url":"https:\/\/namso-gen.co\/blog\/why-is-vlookup-returning-0-when-there-is-a-value\/","name":"Why is VLOOKUP returning 0 when there is a value?","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/#website"},"datePublished":"2023-12-25T16:02:42+00:00","dateModified":"2023-12-25T16:02:42+00:00","description":"**Why is VLOOKUP returning 0 when there is a value?** VLOOKUP is a powerful function in Microsoft Excel that allows you to search for a specific value in","breadcrumb":{"@id":"https:\/\/namso-gen.co\/blog\/why-is-vlookup-returning-0-when-there-is-a-value\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/namso-gen.co\/blog\/why-is-vlookup-returning-0-when-there-is-a-value\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/namso-gen.co\/blog\/why-is-vlookup-returning-0-when-there-is-a-value\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/namso-gen.co\/blog\/"},{"@type":"ListItem","position":2,"name":"Why is VLOOKUP returning 0 when there is a value?"}]},{"@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\/219404","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=219404"}],"version-history":[{"count":0,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/219404\/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=219404"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/categories?post=219404"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/tags?post=219404"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}