{"id":261518,"date":"2024-07-09T19:37:39","date_gmt":"2024-07-09T19:37:39","guid":{"rendered":"https:\/\/namso-gen.co\/blog\/?p=261518"},"modified":"2024-07-09T19:37:39","modified_gmt":"2024-07-09T19:37:39","slug":"how-to-have-match-find-an-adjacent-cell-value","status":"publish","type":"post","link":"https:\/\/namso-gen.co\/blog\/how-to-have-match-find-an-adjacent-cell-value\/","title":{"rendered":"How to have Match find an adjacent cell value?"},"content":{"rendered":"<p>When working with spreadsheets, it is often necessary to find and retrieve values from a particular cell based on specific criteria. Excel provides a powerful function called MATCH that allows you to search for a value in a range and return its relative position. However, what if you want to retrieve not only the matched value but also the value in an adjacent cell? In this article, we will discuss an efficient approach to using the MATCH function to find an adjacent cell value in Excel.<\/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-have-match-find-an-adjacent-cell-value\/#The_MATCH_function_Finding_values_in_a_range\" title=\"The MATCH function: Finding values in a range\">The MATCH function: Finding values in a range<\/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-have-match-find-an-adjacent-cell-value\/#Finding_an_adjacent_cell_value_using_the_MATCH_function\" title=\"Finding an adjacent cell value using the MATCH function\">Finding an adjacent cell value using the MATCH function<\/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-have-match-find-an-adjacent-cell-value\/#How_to_have_Match_find_an_adjacent_cell_value\" title=\"How to have Match find an adjacent cell value?\">How to have Match find an adjacent cell value?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/namso-gen.co\/blog\/how-to-have-match-find-an-adjacent-cell-value\/#Related_FAQs\" title=\"Related FAQs:\">Related FAQs:<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/namso-gen.co\/blog\/how-to-have-match-find-an-adjacent-cell-value\/#1_How_does_the_MATCH_function_work_in_Excel\" title=\"1. How does the MATCH function work in Excel?\">1. How does the MATCH function work 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-have-match-find-an-adjacent-cell-value\/#2_Can_the_MATCH_function_be_used_for_approximate_matches\" title=\"2. Can the MATCH function be used for approximate matches?\">2. Can the MATCH function be used for approximate matches?<\/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-have-match-find-an-adjacent-cell-value\/#3_What_is_the_purpose_of_the_INDEX_function\" title=\"3. What is the purpose of the INDEX function?\">3. What is the purpose of the INDEX function?<\/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-have-match-find-an-adjacent-cell-value\/#4_Is_the_match_type_argument_mandatory_in_the_MATCH_function\" title=\"4. Is the match_type argument mandatory in the MATCH function?\">4. Is the match_type argument mandatory in the MATCH function?<\/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-have-match-find-an-adjacent-cell-value\/#5_How_can_I_return_the_adjacent_cell_value_in_Excel\" title=\"5. How can I return the adjacent cell value in Excel?\">5. How can I return the adjacent cell value in Excel?<\/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-have-match-find-an-adjacent-cell-value\/#6_Can_the_MATCH_function_return_multiple_values\" title=\"6. Can the MATCH function return multiple values?\">6. Can the MATCH function return multiple values?<\/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-have-match-find-an-adjacent-cell-value\/#7_What_should_I_do_if_the_lookup_value_is_not_found_using_the_MATCH_function\" title=\"7. What should I do if the lookup value is not found using the MATCH function?\">7. What should I do if the lookup value is not found using the MATCH function?<\/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-have-match-find-an-adjacent-cell-value\/#8_Can_I_use_the_MATCH_function_to_search_in_multiple_sheets\" title=\"8. Can I use the MATCH function to search in multiple sheets?\">8. Can I use the MATCH function to search in multiple 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-have-match-find-an-adjacent-cell-value\/#9_Can_I_use_the_MATCH_function_with_wildcards\" title=\"9. Can I use the MATCH function with wildcards?\">9. Can I use the MATCH function with wildcards?<\/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-have-match-find-an-adjacent-cell-value\/#10_Can_INDEX_retrieve_values_from_multiple_columns\" title=\"10. Can INDEX retrieve values from multiple columns?\">10. Can INDEX retrieve values from multiple columns?<\/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-have-match-find-an-adjacent-cell-value\/#11_What_happens_if_I_use_a_match_type_argument_other_than_0_or_1\" title=\"11. What happens if I use a match_type argument other than 0 or 1?\">11. What happens if I use a match_type argument other than 0 or 1?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/namso-gen.co\/blog\/how-to-have-match-find-an-adjacent-cell-value\/#12_Can_the_MATCH_function_be_case-sensitive\" title=\"12. Can the MATCH function be case-sensitive?\">12. Can the MATCH function be case-sensitive?<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"The_MATCH_function_Finding_values_in_a_range\"><\/span>The MATCH function: Finding values in a range<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Before we dive into finding an adjacent cell value using the MATCH function, let&#8217;s briefly go over how the function works to find a value in a given range. The MATCH function in Excel helps you locate the position of a lookup value within a specified range of cells. Its syntax is as follows:<\/p>\n<p><b>MATCH(lookup_value, lookup_array, [match_type])<\/b><\/p>\n<p>The <i>lookup_value<\/i> is the value you want to find, the <i>lookup_array<\/i> is the range of cells where you want to search, and the <i>match_type<\/i> (optional) specifies the type of match you are looking for.<\/p>\n<p>By default, if you omit the <i>match_type<\/i> argument, Excel assumes it to be 1, which indicates an approximate match. However, in most cases, a value can be found using an exact match, so we will focus on the exact match scenario.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Finding_an_adjacent_cell_value_using_the_MATCH_function\"><\/span>Finding an adjacent cell value using the MATCH function<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Now that we understand how the MATCH function works, let&#8217;s look at how we can use it to return an adjacent cell value. To do this, we need to combine the MATCH function with another function called INDEX. The INDEX function allows us to retrieve the value at a specific row and column within a given range. Below is an example of how the two functions can be used together:<\/p>\n<p><b>=INDEX(range, MATCH(lookup_value, lookup_array, 0), column)<\/b><\/p>\n<p>In this formula, the <i>range<\/i> is the range of cells where the value you want to retrieve is located. The <i>lookup_value<\/i> and <i>lookup_array<\/i> remain the same as in the MATCH function, but we use &#8220;0&#8221; as the <i>match_type<\/i> argument to indicate an exact match. The <i>column<\/i> argument specifies the column index within the range from which you want to retrieve the adjacent value. <\/p>\n<p>By using this combined formula, you can now easily find the adjacent cell value based on a specific criterion.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"How_to_have_Match_find_an_adjacent_cell_value\"><\/span><b>How to have Match find an adjacent cell value?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To have the MATCH function find an adjacent cell value, you can use the INDEX function in conjunction with it. The formula would look like this:<\/p>\n<p><b>=INDEX(range, MATCH(lookup_value, lookup_array, 0), column)<\/b><\/p>\n<p>By replacing &#8220;range&#8221; with the desired range of cells, &#8220;lookup_value&#8221; with the value you want to search for, &#8220;lookup_array&#8221; with the range where you want to search, and &#8220;column&#8221; with the column index of the adjacent cell you want to retrieve, you can accurately find the adjacent value.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Related_FAQs\"><\/span>Related FAQs:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"1_How_does_the_MATCH_function_work_in_Excel\"><\/span>1. How does the MATCH function work in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>The MATCH function locates the position of a specified value within a range of cells.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"2_Can_the_MATCH_function_be_used_for_approximate_matches\"><\/span>2. Can the MATCH function be used for approximate matches?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>Yes, by using a match_type argument of 1, the MATCH function can perform approximate matches.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"3_What_is_the_purpose_of_the_INDEX_function\"><\/span>3. What is the purpose of the INDEX function?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>The INDEX function is used to retrieve a value at a specified position within a range.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"4_Is_the_match_type_argument_mandatory_in_the_MATCH_function\"><\/span>4. Is the match_type argument mandatory in the MATCH function?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>No, if you omit the match_type argument, Excel assumes an approximate match by default (match_type = 1).<\/p>\n<h3><span class=\"ez-toc-section\" id=\"5_How_can_I_return_the_adjacent_cell_value_in_Excel\"><\/span>5. How can I return the adjacent cell value in Excel?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>You can use the INDEX function in combination with the MATCH function to retrieve the adjacent cell value in Excel.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"6_Can_the_MATCH_function_return_multiple_values\"><\/span>6. Can the MATCH function return multiple values?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>No, the MATCH function only returns the position of the first occurrence of the matched value.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"7_What_should_I_do_if_the_lookup_value_is_not_found_using_the_MATCH_function\"><\/span>7. What should I do if the lookup value is not found using the MATCH function?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>If the lookup value is not found, the MATCH function returns an error value (#N\/A).<\/p>\n<h3><span class=\"ez-toc-section\" id=\"8_Can_I_use_the_MATCH_function_to_search_in_multiple_sheets\"><\/span>8. Can I use the MATCH function to search in multiple sheets?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>Yes, you can use the MATCH function to search in multiple sheets by specifying the range across the sheets.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"9_Can_I_use_the_MATCH_function_with_wildcards\"><\/span>9. Can I use the MATCH function with wildcards?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>No, the MATCH function does not support wildcards. For wildcard searches, you can use other functions like COUNTIF or VLOOKUP.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"10_Can_INDEX_retrieve_values_from_multiple_columns\"><\/span>10. Can INDEX retrieve values from multiple columns?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>Yes, the INDEX function can retrieve values from multiple columns by specifying a range that covers all the desired columns.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"11_What_happens_if_I_use_a_match_type_argument_other_than_0_or_1\"><\/span>11. What happens if I use a match_type argument other than 0 or 1?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>Using a match_type argument other than 0 or 1 will result in an error. Only 0 or 1 are valid match_type arguments for exact and approximate matches, respectively.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"12_Can_the_MATCH_function_be_case-sensitive\"><\/span>12. Can the MATCH function be case-sensitive?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><\/p>\n<p>No, by default, the MATCH function is not case-sensitive. To perform a case-sensitive match, you can use the EXACT function in combination with MATCH.<\/p>\n<p>Using the MATCH function in combination with the INDEX function opens up a world of possibilities for retrieving adjacent cell values based on specific criteria. By following the steps outlined in this article, you can enhance your spreadsheet analysis and streamline your data retrieval process in Excel.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When working with spreadsheets, it is often necessary to find and retrieve values from a particular cell based on specific criteria. Excel provides a powerful function called MATCH that allows you to search for a value in a range and return its relative position. However, what if you want to retrieve not only the matched &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to have Match find an adjacent cell value?\" class=\"read-more button\" href=\"https:\/\/namso-gen.co\/blog\/how-to-have-match-find-an-adjacent-cell-value\/#more-261518\">Read more<span class=\"screen-reader-text\">How to have Match find an adjacent cell 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-261518","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 have Match find an adjacent cell value?<\/title>\n<meta name=\"description\" content=\"When working with spreadsheets, it is often necessary to find and retrieve values from a particular cell based on specific criteria. Excel provides a\" \/>\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-have-match-find-an-adjacent-cell-value\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to have Match find an adjacent cell value?\" \/>\n<meta property=\"og:description\" content=\"When working with spreadsheets, it is often necessary to find and retrieve values from a particular cell based on specific criteria. Excel provides a\" \/>\n<meta property=\"og:url\" content=\"https:\/\/namso-gen.co\/blog\/how-to-have-match-find-an-adjacent-cell-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-07-09T19:37:39+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-have-match-find-an-adjacent-cell-value\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-have-match-find-an-adjacent-cell-value\/\"},\"author\":{\"name\":\"Jamie Steele\",\"@id\":\"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/4938663f06a1cff2dff5c1af38d151c0\"},\"headline\":\"How to have Match find an adjacent cell value?\",\"datePublished\":\"2024-07-09T19:37:39+00:00\",\"dateModified\":\"2024-07-09T19:37:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-have-match-find-an-adjacent-cell-value\/\"},\"wordCount\":890,\"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-have-match-find-an-adjacent-cell-value\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-have-match-find-an-adjacent-cell-value\/\",\"url\":\"https:\/\/namso-gen.co\/blog\/how-to-have-match-find-an-adjacent-cell-value\/\",\"name\":\"How to have Match find an adjacent cell value?\",\"isPartOf\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/#website\"},\"datePublished\":\"2024-07-09T19:37:39+00:00\",\"dateModified\":\"2024-07-09T19:37:39+00:00\",\"description\":\"When working with spreadsheets, it is often necessary to find and retrieve values from a particular cell based on specific criteria. Excel provides a\",\"breadcrumb\":{\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-have-match-find-an-adjacent-cell-value\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/namso-gen.co\/blog\/how-to-have-match-find-an-adjacent-cell-value\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/namso-gen.co\/blog\/how-to-have-match-find-an-adjacent-cell-value\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/namso-gen.co\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to have Match find an adjacent cell 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 have Match find an adjacent cell value?","description":"When working with spreadsheets, it is often necessary to find and retrieve values from a particular cell based on specific criteria. Excel provides a","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-have-match-find-an-adjacent-cell-value\/","og_locale":"en_US","og_type":"article","og_title":"How to have Match find an adjacent cell value?","og_description":"When working with spreadsheets, it is often necessary to find and retrieve values from a particular cell based on specific criteria. Excel provides a","og_url":"https:\/\/namso-gen.co\/blog\/how-to-have-match-find-an-adjacent-cell-value\/","og_site_name":"Namso Gen Blog - Free Credit Card Generator [100% Valid]","article_publisher":"https:\/\/www.facebook.com\/synchronyfinancial","article_published_time":"2024-07-09T19:37:39+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-have-match-find-an-adjacent-cell-value\/#article","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-have-match-find-an-adjacent-cell-value\/"},"author":{"name":"Jamie Steele","@id":"https:\/\/namso-gen.co\/blog\/#\/schema\/person\/4938663f06a1cff2dff5c1af38d151c0"},"headline":"How to have Match find an adjacent cell value?","datePublished":"2024-07-09T19:37:39+00:00","dateModified":"2024-07-09T19:37:39+00:00","mainEntityOfPage":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-have-match-find-an-adjacent-cell-value\/"},"wordCount":890,"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-have-match-find-an-adjacent-cell-value\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/namso-gen.co\/blog\/how-to-have-match-find-an-adjacent-cell-value\/","url":"https:\/\/namso-gen.co\/blog\/how-to-have-match-find-an-adjacent-cell-value\/","name":"How to have Match find an adjacent cell value?","isPartOf":{"@id":"https:\/\/namso-gen.co\/blog\/#website"},"datePublished":"2024-07-09T19:37:39+00:00","dateModified":"2024-07-09T19:37:39+00:00","description":"When working with spreadsheets, it is often necessary to find and retrieve values from a particular cell based on specific criteria. Excel provides a","breadcrumb":{"@id":"https:\/\/namso-gen.co\/blog\/how-to-have-match-find-an-adjacent-cell-value\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/namso-gen.co\/blog\/how-to-have-match-find-an-adjacent-cell-value\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/namso-gen.co\/blog\/how-to-have-match-find-an-adjacent-cell-value\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/namso-gen.co\/blog\/"},{"@type":"ListItem","position":2,"name":"How to have Match find an adjacent cell 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\/261518","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=261518"}],"version-history":[{"count":0,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/posts\/261518\/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=261518"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/categories?post=261518"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/namso-gen.co\/blog\/wp-json\/wp\/v2\/tags?post=261518"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}