{"id":261858,"date":"2024-05-10T18:00:50","date_gmt":"2024-05-10T18:00:50","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/?p=261858"},"modified":"2024-05-10T18:00:50","modified_gmt":"2024-05-10T18:00:50","slug":"how-to-use-vlookup-to-find-more-than-one-value","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-use-vlookup-to-find-more-than-one-value\/","title":{"rendered":"How to use VLOOKUP to find more than one value?"},"content":{"rendered":"<p>When working with large datasets in Microsoft Excel, it&#8217;s common to come across situations where you need to find multiple values using a single lookup value. While the VLOOKUP function in Excel is primarily designed to find a single value, there are a few techniques you can apply to work around this limitation and retrieve multiple values. In this article, we will explore how to use VLOOKUP to find more than one value efficiently.<\/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-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/namso-gen.co\/blog\/how-to-use-vlookup-to-find-more-than-one-value\/#The_VLOOKUP_Function\" title=\"The VLOOKUP Function\">The VLOOKUP Function<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/namso-gen.co\/blog\/how-to-use-vlookup-to-find-more-than-one-value\/#How_to_Use_VLOOKUP_to_Find_More_Than_One_Value\" title=\"How to Use VLOOKUP to Find More Than One Value?\">How to Use VLOOKUP to Find More Than One Value?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/namso-gen.co\/blog\/how-to-use-vlookup-to-find-more-than-one-value\/#Frequently_Asked_Questions_FAQs\" title=\"Frequently Asked Questions (FAQs):\">Frequently Asked Questions (FAQs):<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/namso-gen.co\/blog\/how-to-use-vlookup-to-find-more-than-one-value\/#1_Can_VLOOKUP_retrieve_multiple_values\" title=\"1. Can VLOOKUP retrieve multiple values?\">1. Can VLOOKUP retrieve multiple values?<\/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\/how-to-use-vlookup-to-find-more-than-one-value\/#2_What_is_an_array_formula_in_Excel\" title=\"2. What is an array formula in Excel?\">2. What is an array formula in Excel?<\/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\/how-to-use-vlookup-to-find-more-than-one-value\/#3_How_do_I_make_an_array_formula_to_find_multiple_values_using_VLOOKUP\" title=\"3. How do I make an array formula to find multiple values using VLOOKUP?\">3. How do I make an array formula to find multiple values using VLOOKUP?<\/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\/how-to-use-vlookup-to-find-more-than-one-value\/#4_What_is_the_purpose_of_the_IFERROR_function_in_the_array_formula\" title=\"4. What is the purpose of the IFERROR function in the array formula?\">4. What is the purpose of the IFERROR function in the array 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\/how-to-use-vlookup-to-find-more-than-one-value\/#5_Can_I_use_VLOOKUP_to_retrieve_multiple_values_horizontally\" title=\"5. Can I use VLOOKUP to retrieve multiple values horizontally?\">5. Can I use VLOOKUP to retrieve multiple values horizontally?<\/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\/how-to-use-vlookup-to-find-more-than-one-value\/#6_How_does_the_SMALL_function_work_in_the_array_formula\" title=\"6. How does the SMALL function work in the array formula?\">6. How does the SMALL function work in the array formula?<\/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\/how-to-use-vlookup-to-find-more-than-one-value\/#7_Does_the_modified_VLOOKUP_formula_work_with_approximate_matches\" title=\"7. Does the modified VLOOKUP formula work with approximate matches?\">7. Does the modified VLOOKUP formula work with approximate matches?<\/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\/how-to-use-vlookup-to-find-more-than-one-value\/#8_Can_I_use_the_modified_VLOOKUP_formula_with_named_ranges\" title=\"8. Can I use the modified VLOOKUP formula with named ranges?\">8. Can I use the modified VLOOKUP formula with named ranges?<\/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\/how-to-use-vlookup-to-find-more-than-one-value\/#9_Is_it_possible_to_apply_this_technique_to_find_multiple_values_across_different_sheets\" title=\"9. Is it possible to apply this technique to find multiple values across different sheets?\">9. Is it possible to apply this technique to find multiple values across different sheets?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/namso-gen.co\/blog\/how-to-use-vlookup-to-find-more-than-one-value\/#10_Are_there_any_limitations_to_the_number_of_results_this_formula_can_retrieve\" title=\"10. Are there any limitations to the number of results this formula can retrieve?\">10. Are there any limitations to the number of results this formula can retrieve?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/namso-gen.co\/blog\/how-to-use-vlookup-to-find-more-than-one-value\/#11_Can_I_add_additional_criteria_to_the_modified_VLOOKUP_formula\" title=\"11. Can I add additional criteria to the modified VLOOKUP formula?\">11. Can I add additional criteria to the modified VLOOKUP formula?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/namso-gen.co\/blog\/how-to-use-vlookup-to-find-more-than-one-value\/#12_How_can_I_avoid_entering_the_array_formula_for_each_cell\" title=\"12. How can I avoid entering the array formula for each cell?\">12. How can I avoid entering the array formula for each cell?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"The_VLOOKUP_Function\"><\/span>The VLOOKUP Function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Before diving into finding multiple values, let&#8217;s have a quick overview of the VLOOKUP function itself. VLOOKUP is an Excel function used to retrieve information from a table based on a lookup value. It works vertically, searching for values in a specific column and returning a matching result from a corresponding column.<\/p>\n<p>The basic syntax for VLOOKUP is as follows:<\/p>\n<p>  <code>=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])<\/code><\/p>\n<ul><\/p>\n<li><b>lookup_value:<\/b> The value you want to search for.<\/li>\n<p><\/p>\n<li><b>table_array:<\/b> The range of cells where the lookup value exists along with the corresponding result.<\/li>\n<p><\/p>\n<li><b>col_index_num:<\/b> The column number in the table_array from which to return the result (the numbering starts from 1).<\/li>\n<p><\/p>\n<li><b>range_lookup:<\/b> Optional. Specifies whether you want an approximate match or an exact match.<\/li>\n<p>\n<\/ul>\n<p>It&#8217;s important to note that the VLOOKUP function only retrieves the first matching result it encounters. To find multiple values, we&#8217;ll need to apply some additional techniques.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"How_to_Use_VLOOKUP_to_Find_More_Than_One_Value\"><\/span><b>How to Use VLOOKUP to Find More Than One Value?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To find more than one value using VLOOKUP, we&#8217;ll take advantage of an array formula. Array formulas allow us to perform calculations on multiple values in an array. Thus, by modifying the VLOOKUP function to operate on an array, we can retrieve multiple results. Follow the steps below to achieve this:<\/p>\n<p>1. Prepare a column for the lookup values: Suppose you have a range of values in column A that you want to search for in a table.<br \/>\n2. Select an empty range of cells in another column, where you want to display the results.<br \/>\n3. Enter the following formula as an array formula by pressing <b>Ctrl+Shift+Enter<\/b> instead of just Enter:<\/p>\n<p>    <code>=IFERROR(INDEX(result_array, SMALL(IF(lookup_array=lookup_value, ROW(lookup_array)-MIN(ROW(lookup_array))+1), ROWS(A$1:A1))), \"\")<\/code><\/p>\n<p>4. Replace <b>result_array<\/b> with the range of cells containing the values you want to display for each lookup value.<br \/>\n5. Replace <b>lookup_array<\/b> with the range of cells containing the lookup values.<br \/>\n6. Replace <b>lookup_value<\/b> with the cell reference of the first lookup value in the lookup_array.<br \/>\n7. Drag down the formula to populate the remaining cells in the result column.<\/p>\n<p>This modified VLOOKUP formula with the IFERROR, INDEX, and SMALL functions allows us to extract multiple results for the specified lookup values from the result_array.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Frequently_Asked_Questions_FAQs\"><\/span><b>Frequently Asked Questions (FAQs):<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"1_Can_VLOOKUP_retrieve_multiple_values\"><\/span>1. Can VLOOKUP retrieve multiple values?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nNo, VLOOKUP alone can only retrieve the first matching result it finds.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_What_is_an_array_formula_in_Excel\"><\/span>2. What is an array formula in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nArray formulas in Excel perform calculations on multiple values in an array rather than a single value. They are enclosed in curly braces { } and must be entered with Ctrl+Shift+Enter.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_How_do_I_make_an_array_formula_to_find_multiple_values_using_VLOOKUP\"><\/span>3. How do I make an array formula to find multiple values using VLOOKUP?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nBy modifying the VLOOKUP formula to operate on an array and using additional functions like IF and INDEX, you can retrieve multiple values.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_What_is_the_purpose_of_the_IFERROR_function_in_the_array_formula\"><\/span>4. What is the purpose of the IFERROR function in the array formula?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThe IFERROR function handles any errors that may arise in the formula and replaces them with an empty string (&#8220;&#8221;).<\/p>\n<h3><span class=\"ez-toc-section\" id=\"5_Can_I_use_VLOOKUP_to_retrieve_multiple_values_horizontally\"><\/span>5. Can I use VLOOKUP to retrieve multiple values horizontally?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can modify the array formula by using the TRANSPOSE function to return results horizontally instead of vertically.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"6_How_does_the_SMALL_function_work_in_the_array_formula\"><\/span>6. How does the SMALL function work in the array formula?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThe SMALL function is used to retrieve the nth smallest value from an array. In this case, it helps generate the row numbers for the matching values.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"7_Does_the_modified_VLOOKUP_formula_work_with_approximate_matches\"><\/span>7. Does the modified VLOOKUP formula work with approximate matches?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nNo, the modified formula only works with exact matches. If you need to find approximate matches, you can explore other functions like INDEX and MATCH.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"8_Can_I_use_the_modified_VLOOKUP_formula_with_named_ranges\"><\/span>8. Can I use the modified VLOOKUP formula with named ranges?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can use named ranges in place of cell references for both the lookup_array and result_array.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"9_Is_it_possible_to_apply_this_technique_to_find_multiple_values_across_different_sheets\"><\/span>9. Is it possible to apply this technique to find multiple values across different sheets?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can extend this technique across different sheets by prefixing the sheet name along with the cell reference.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"10_Are_there_any_limitations_to_the_number_of_results_this_formula_can_retrieve\"><\/span>10. Are there any limitations to the number of results this formula can retrieve?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThis formula does not have a specific limitation on the number of results it can retrieve. However, it may become slower or less efficient for very large datasets.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"11_Can_I_add_additional_criteria_to_the_modified_VLOOKUP_formula\"><\/span>11. Can I add additional criteria to the modified VLOOKUP formula?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYou can add additional criteria by using logical operators like AND or OR within the IF function to specify multiple conditions for the lookup.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"12_How_can_I_avoid_entering_the_array_formula_for_each_cell\"><\/span>12. How can I avoid entering the array formula for each cell?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nInstead of dragging the formula down, you can use the INDEX function&#8217;s array functionality to automatically populate the results for the entire range by modifying the row_num argument.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When working with large datasets in Microsoft Excel, it&#8217;s common to come across situations where you need to find multiple values using a single lookup value. While the VLOOKUP function in Excel is primarily designed to find a single value, there are a few techniques you can apply to work around this limitation and retrieve &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to use VLOOKUP to find more than one value?\" class=\"read-more button\" href=\"https:\/\/namso-gen.co\/blog\/how-to-use-vlookup-to-find-more-than-one-value\/#more-261858\">Read more<span class=\"screen-reader-text\">How to use VLOOKUP to find more than one value?<\/span><\/a><\/p>\n","protected":false},"author":66,"featured_media":107420,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[86279],"tags":[],"class_list":["post-261858","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>How to use VLOOKUP to find more than one value?<\/title>\n<meta name=\"description\" content=\"When working with large datasets in Microsoft Excel, it&#039;s common to come across situations where you need to find multiple values using a single lookup\" \/>\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\/how-to-use-vlookup-to-find-more-than-one-value\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to use VLOOKUP to find more than one value?\" \/>\n<meta property=\"og:description\" content=\"When working with large datasets in Microsoft Excel, it&#039;s common to come across situations where you need to find multiple values using a single lookup\" \/>\n<meta property=\"og:url\" content=\"https:\/\/namso-gen.co\/blog\/how-to-use-vlookup-to-find-more-than-one-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=\"2024-05-10T18:00:50+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2024\/03\/faq.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Jamie Steele\" \/>\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=\"Jamie Steele\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-use-vlookup-to-find-more-than-one-value\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-use-vlookup-to-find-more-than-one-value\/\"},\"author\":{\"name\":\"Jamie Steele\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/4938663f06a1cff2dff5c1af38d151c0\"},\"headline\":\"How to use VLOOKUP to find more than one value?\",\"datePublished\":\"2024-05-10T18:00:50+00:00\",\"dateModified\":\"2024-05-10T18:00:50+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-use-vlookup-to-find-more-than-one-value\/\"},\"wordCount\":841,\"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\/how-to-use-vlookup-to-find-more-than-one-value\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-use-vlookup-to-find-more-than-one-value\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/how-to-use-vlookup-to-find-more-than-one-value\/\",\"name\":\"How to use VLOOKUP to find more than one value?\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\"},\"datePublished\":\"2024-05-10T18:00:50+00:00\",\"dateModified\":\"2024-05-10T18:00:50+00:00\",\"description\":\"When working with large datasets in Microsoft Excel, it's common to come across situations where you need to find multiple values using a single lookup\",\"breadcrumb\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-use-vlookup-to-find-more-than-one-value\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-use-vlookup-to-find-more-than-one-value\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-use-vlookup-to-find-more-than-one-value\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/namso-gen.co\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to use VLOOKUP to find more than one 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\/4938663f06a1cff2dff5c1af38d151c0\",\"name\":\"Jamie Steele\",\"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\":\"Jamie Steele\"},\"description\":\"Guest author Jamie Steele 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":"How to use VLOOKUP to find more than one value?","description":"When working with large datasets in Microsoft Excel, it's common to come across situations where you need to find multiple values using a single lookup","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\/how-to-use-vlookup-to-find-more-than-one-value\/","og_locale":"en_US","og_type":"article","og_title":"How to use VLOOKUP to find more than one value?","og_description":"When working with large datasets in Microsoft Excel, it's common to come across situations where you need to find multiple values using a single lookup","og_url":"https:\/\/namso-gen.co\/blog\/how-to-use-vlookup-to-find-more-than-one-value\/","og_site_name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","article_publisher":"https:\/\/www.facebook.com\/synchronyfinancial","article_published_time":"2024-05-10T18:00:50+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/namso-gen.co\/blog\/wp-content\/uploads\/2024\/03\/faq.png","type":"image\/png"}],"author":"Jamie Steele","twitter_card":"summary_large_image","twitter_creator":"@synchrony","twitter_site":"@synchrony","twitter_misc":{"Written by":"Jamie Steele","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/namso-gen.co\/blog\/how-to-use-vlookup-to-find-more-than-one-value\/#article","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-use-vlookup-to-find-more-than-one-value\/"},"author":{"name":"Jamie Steele","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/4938663f06a1cff2dff5c1af38d151c0"},"headline":"How to use VLOOKUP to find more than one value?","datePublished":"2024-05-10T18:00:50+00:00","dateModified":"2024-05-10T18:00:50+00:00","mainEntityOfPage":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-use-vlookup-to-find-more-than-one-value\/"},"wordCount":841,"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\/how-to-use-vlookup-to-find-more-than-one-value\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/namso-gen.co\/blog\/how-to-use-vlookup-to-find-more-than-one-value\/","url":"https:\/\/namso-gen.co\/blog\/how-to-use-vlookup-to-find-more-than-one-value\/","name":"How to use VLOOKUP to find more than one value?","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/#website"},"datePublished":"2024-05-10T18:00:50+00:00","dateModified":"2024-05-10T18:00:50+00:00","description":"When working with large datasets in Microsoft Excel, it's common to come across situations where you need to find multiple values using a single lookup","breadcrumb":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-use-vlookup-to-find-more-than-one-value\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/namso-gen.co\/blog\/how-to-use-vlookup-to-find-more-than-one-value\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/namso-gen.co\/blog\/how-to-use-vlookup-to-find-more-than-one-value\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/namso-gen.co\/blog\/"},{"@type":"ListItem","position":2,"name":"How to use VLOOKUP to find more than one 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\/4938663f06a1cff2dff5c1af38d151c0","name":"Jamie Steele","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":"Jamie Steele"},"description":"Guest author Jamie Steele 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\/261858","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\/66"}],"replies":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/comments?post=261858"}],"version-history":[{"count":0,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/261858\/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=261858"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/categories?post=261858"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/tags?post=261858"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}