{"id":229578,"date":"2024-03-29T22:14:21","date_gmt":"2024-03-29T22:14:21","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/?p=229578"},"modified":"2024-03-29T22:14:21","modified_gmt":"2024-03-29T22:14:21","slug":"how-to-lookup-value-in-excel-with-2-conditions","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-lookup-value-in-excel-with-2-conditions\/","title":{"rendered":"How to lookup value in Excel with 2 conditions?"},"content":{"rendered":"<p>Excel is a powerful tool that allows users to perform various data analysis tasks efficiently. One of the common tasks is looking up values based on two or more criteria. In this article, we will explore different methods to lookup values in Excel using two conditions and provide step-by-step instructions.<\/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-lookup-value-in-excel-with-2-conditions\/#Method_1_Using_the_INDEX_and_MATCH_Functions\" title=\"Method 1: Using the INDEX and MATCH Functions\">Method 1: Using the INDEX and MATCH Functions<\/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-lookup-value-in-excel-with-2-conditions\/#Method_2_Using_the_VLOOKUP_Function_with_Multiple_Criteria\" title=\"Method 2: Using the VLOOKUP Function with Multiple Criteria\">Method 2: Using the VLOOKUP Function with Multiple Criteria<\/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-lookup-value-in-excel-with-2-conditions\/#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-lookup-value-in-excel-with-2-conditions\/#1_Can_I_look_up_values_in_Excel_using_more_than_two_conditions\" title=\"1. Can I look up values in Excel using more than two conditions?\">1. Can I look up values in Excel using more than two conditions?<\/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-lookup-value-in-excel-with-2-conditions\/#2_Is_it_possible_to_use_wildcards_or_partial_matches_in_a_two-condition_lookup\" title=\"2. Is it possible to use wildcards or partial matches in a two-condition lookup?\">2. Is it possible to use wildcards or partial matches in a two-condition lookup?<\/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-lookup-value-in-excel-with-2-conditions\/#3_What_does_the_zero_at_the_end_of_the_INDEX_and_MATCH_formula_or_VLOOKUP_formula_signify\" title=\"3. What does the zero at the end of the INDEX and MATCH formula or VLOOKUP formula signify?\">3. What does the zero at the end of the INDEX and MATCH formula or VLOOKUP formula signify?<\/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-lookup-value-in-excel-with-2-conditions\/#4_How_do_I_lookup_values_in_Excel_with_two_conditions_where_one_condition_is_based_on_a_range_of_values\" title=\"4. How do I lookup values in Excel with two conditions where one condition is based on a range of values?\">4. How do I lookup values in Excel with two conditions where one condition is based on a range of 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\/how-to-lookup-value-in-excel-with-2-conditions\/#5_Can_I_use_named_ranges_instead_of_cell_references_in_the_lookup_formulas\" title=\"5. Can I use named ranges instead of cell references in the lookup formulas?\">5. Can I use named ranges instead of cell references in the lookup formulas?<\/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-lookup-value-in-excel-with-2-conditions\/#6_What_happens_if_there_are_multiple_matches_for_the_two_conditions\" title=\"6. What happens if there are multiple matches for the two conditions?\">6. What happens if there are multiple matches for the two conditions?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Method_1_Using_the_INDEX_and_MATCH_Functions\"><\/span>Method 1: Using the INDEX and MATCH Functions<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>The straightforward approach to lookup a value in Excel with two conditions is to use the combination of the INDEX and MATCH functions.<\/b> Follow the steps below:<\/p>\n<p>1. Identify the two criteria columns and the result column in your dataset.<br \/>\n2. In a new cell, enter the following formula: =INDEX(ResultColumn, MATCH(Condition1&#038;Condition2, CriteriaColumn1&#038;CriteriaColumn2, 0))<br \/>\n   &#8211; Replace ResultColumn with the range of cells that contain the desired result.<br \/>\n   &#8211; Replace Condition1 and Condition2 with the specific criteria you want to match against.<br \/>\n   &#8211; Replace CriteriaColumn1 and CriteriaColumn2 with the respective columns that contain the criteria.<br \/>\n   &#8211; The &#8220;&#038;&#8221; sign concatenates the two conditions for comparison.<br \/>\n   &#8211; The zero at the end represents an exact match.<br \/>\n3. Press Enter to get the lookup result.<\/p>\n<p>This method ensures that the lookup is performed based on the two specified conditions, and the result is returned accurately.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Method_2_Using_the_VLOOKUP_Function_with_Multiple_Criteria\"><\/span>Method 2: Using the VLOOKUP Function with Multiple Criteria<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you prefer using the VLOOKUP function, you can also achieve a two-condition lookup with a slight modification. Here&#8217;s how:<\/p>\n<p>1. Create a helper column in your dataset that combines the two conditions into one string using the CONCATENATE function. For example, if your criteria are in columns A and B, the helper column formula would be =CONCATENATE(A2,B2).<br \/>\n2. Sort your dataset based on the helper column in ascending order to ensure accurate lookup results.<br \/>\n3. In a new cell, use the VLOOKUP function as follows: =VLOOKUP(Condition1&#038;Condition2, SortedRange, ResultColumnIndex, 0)<br \/>\n   &#8211; Replace Condition1 and Condition2 with the specific criteria.<br \/>\n   &#8211; Replace SortedRange with the range of cells that includes both the helper column and the result column.<br \/>\n   &#8211; Replace ResultColumnIndex with the relative position of the result column in the SortedRange.<br \/>\n   &#8211; The zero at the end represents an exact match.<br \/>\n4. Press Enter to obtain the lookup result.<\/p>\n<p>This method effectively utilizes the VLOOKUP function by concatenating the conditions into one string and sorting the dataset accordingly.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Frequently_Asked_Questions_FAQs\"><\/span>Frequently Asked Questions (FAQs)<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"1_Can_I_look_up_values_in_Excel_using_more_than_two_conditions\"><\/span>1. Can I look up values in Excel using more than two conditions?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can. The methods discussed above can be extended to accommodate additional criteria by concatenating them together within the lookup formulas.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Is_it_possible_to_use_wildcards_or_partial_matches_in_a_two-condition_lookup\"><\/span>2. Is it possible to use wildcards or partial matches in a two-condition lookup?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can use wildcards or partial matches by modifying the criteria within the lookup formulas. For example, you can use the &#8220;*&#8221; wildcard to represent any characters in a condition.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_What_does_the_zero_at_the_end_of_the_INDEX_and_MATCH_formula_or_VLOOKUP_formula_signify\"><\/span>3. What does the zero at the end of the INDEX and MATCH formula or VLOOKUP formula signify?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nThe zero indicates that an exact match is required for the lookup to return the result. If a match is not found, an error will be displayed.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_How_do_I_lookup_values_in_Excel_with_two_conditions_where_one_condition_is_based_on_a_range_of_values\"><\/span>4. How do I lookup values in Excel with two conditions where one condition is based on a range of values?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nTo lookup values when one condition involves a range, you can use the combination of the INDEX, MATCH, and COUNTIFS functions. By counting the number of occurrences of the range condition, you can return the corresponding result.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"5_Can_I_use_named_ranges_instead_of_cell_references_in_the_lookup_formulas\"><\/span>5. Can I use named ranges instead of cell references in the lookup formulas?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nYes, you can use named ranges to make your formulas more readable and easier to maintain. Instead of specifying cell references, you can use the defined names in the formulas.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"6_What_happens_if_there_are_multiple_matches_for_the_two_conditions\"><\/span>6. What happens if there are multiple matches for the two conditions?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\nIf there are multiple matches for the two conditions, the lookup formulas will return the value of the first occurrence found in the dataset.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel is a powerful tool that allows users to perform various data analysis tasks efficiently. One of the common tasks is looking up values based on two or more criteria. In this article, we will explore different methods to lookup values in Excel using two conditions and provide step-by-step instructions. Method 1: Using the INDEX &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to lookup value in Excel with 2 conditions?\" class=\"read-more button\" href=\"https:\/\/namso-gen.co\/blog\/how-to-lookup-value-in-excel-with-2-conditions\/#more-229578\">Read more<span class=\"screen-reader-text\">How to lookup value in Excel with 2 conditions?<\/span><\/a><\/p>\n","protected":false},"author":57,"featured_media":107420,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[86279],"tags":[],"class_list":["post-229578","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 lookup value in Excel with 2 conditions?<\/title>\n<meta name=\"description\" content=\"Excel is a powerful tool that allows users to perform various data analysis tasks efficiently. One of the common tasks is looking up values based on two\" \/>\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-lookup-value-in-excel-with-2-conditions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to lookup value in Excel with 2 conditions?\" \/>\n<meta property=\"og:description\" content=\"Excel is a powerful tool that allows users to perform various data analysis tasks efficiently. One of the common tasks is looking up values based on two\" \/>\n<meta property=\"og:url\" content=\"https:\/\/namso-gen.co\/blog\/how-to-lookup-value-in-excel-with-2-conditions\/\" \/>\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-03-29T22:14:21+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=\"Casey Mayer\" \/>\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=\"Casey Mayer\" \/>\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\/how-to-lookup-value-in-excel-with-2-conditions\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-lookup-value-in-excel-with-2-conditions\/\"},\"author\":{\"name\":\"Casey Mayer\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/89e431077ef417dfaa131f435124f18f\"},\"headline\":\"How to lookup value in Excel with 2 conditions?\",\"datePublished\":\"2024-03-29T22:14:21+00:00\",\"dateModified\":\"2024-03-29T22:14:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-lookup-value-in-excel-with-2-conditions\/\"},\"wordCount\":640,\"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-lookup-value-in-excel-with-2-conditions\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-lookup-value-in-excel-with-2-conditions\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/how-to-lookup-value-in-excel-with-2-conditions\/\",\"name\":\"How to lookup value in Excel with 2 conditions?\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\"},\"datePublished\":\"2024-03-29T22:14:21+00:00\",\"dateModified\":\"2024-03-29T22:14:21+00:00\",\"description\":\"Excel is a powerful tool that allows users to perform various data analysis tasks efficiently. One of the common tasks is looking up values based on two\",\"breadcrumb\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-lookup-value-in-excel-with-2-conditions\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-lookup-value-in-excel-with-2-conditions\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-lookup-value-in-excel-with-2-conditions\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/namso-gen.co\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to lookup value in Excel with 2 conditions?\"}]},{\"@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\/89e431077ef417dfaa131f435124f18f\",\"name\":\"Casey Mayer\",\"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\":\"Casey Mayer\"},\"description\":\"Guest author Casey Mayer 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 lookup value in Excel with 2 conditions?","description":"Excel is a powerful tool that allows users to perform various data analysis tasks efficiently. One of the common tasks is looking up values based on two","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-lookup-value-in-excel-with-2-conditions\/","og_locale":"en_US","og_type":"article","og_title":"How to lookup value in Excel with 2 conditions?","og_description":"Excel is a powerful tool that allows users to perform various data analysis tasks efficiently. One of the common tasks is looking up values based on two","og_url":"https:\/\/namso-gen.co\/blog\/how-to-lookup-value-in-excel-with-2-conditions\/","og_site_name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","article_publisher":"https:\/\/www.facebook.com\/synchronyfinancial","article_published_time":"2024-03-29T22:14:21+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":"Casey Mayer","twitter_card":"summary_large_image","twitter_creator":"@synchrony","twitter_site":"@synchrony","twitter_misc":{"Written by":"Casey Mayer","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/namso-gen.co\/blog\/how-to-lookup-value-in-excel-with-2-conditions\/#article","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-lookup-value-in-excel-with-2-conditions\/"},"author":{"name":"Casey Mayer","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/89e431077ef417dfaa131f435124f18f"},"headline":"How to lookup value in Excel with 2 conditions?","datePublished":"2024-03-29T22:14:21+00:00","dateModified":"2024-03-29T22:14:21+00:00","mainEntityOfPage":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-lookup-value-in-excel-with-2-conditions\/"},"wordCount":640,"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-lookup-value-in-excel-with-2-conditions\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/namso-gen.co\/blog\/how-to-lookup-value-in-excel-with-2-conditions\/","url":"https:\/\/namso-gen.co\/blog\/how-to-lookup-value-in-excel-with-2-conditions\/","name":"How to lookup value in Excel with 2 conditions?","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/#website"},"datePublished":"2024-03-29T22:14:21+00:00","dateModified":"2024-03-29T22:14:21+00:00","description":"Excel is a powerful tool that allows users to perform various data analysis tasks efficiently. One of the common tasks is looking up values based on two","breadcrumb":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-lookup-value-in-excel-with-2-conditions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/namso-gen.co\/blog\/how-to-lookup-value-in-excel-with-2-conditions\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/namso-gen.co\/blog\/how-to-lookup-value-in-excel-with-2-conditions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/namso-gen.co\/blog\/"},{"@type":"ListItem","position":2,"name":"How to lookup value in Excel with 2 conditions?"}]},{"@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\/89e431077ef417dfaa131f435124f18f","name":"Casey Mayer","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":"Casey Mayer"},"description":"Guest author Casey Mayer 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\/229578","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\/57"}],"replies":[{"embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/comments?post=229578"}],"version-history":[{"count":0,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/229578\/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=229578"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/categories?post=229578"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/tags?post=229578"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}