{"id":30621,"date":"2023-08-25T10:31:14","date_gmt":"2023-08-25T08:31:14","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=30621"},"modified":"2024-03-28T23:57:02","modified_gmt":"2024-03-28T22:57:02","slug":"match-function-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/match-function-in-excel\/","title":{"rendered":"Unlock the Power of the MATCH Function &#8211; Top 3 Examples"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/C3251332-A869-4C6C-A2B9-E1E48E84A538-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-30670\" title=\"Unlock the Power of the MATCH Function - Top 3 Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/C3251332-A869-4C6C-A2B9-E1E48E84A538-1-1024x576.png\" alt=\"Unlock the Power of the MATCH Function - Top 3 Examples\" width=\"1024\" height=\"576\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/C3251332-A869-4C6C-A2B9-E1E48E84A538-1-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/C3251332-A869-4C6C-A2B9-E1E48E84A538-1-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/C3251332-A869-4C6C-A2B9-E1E48E84A538-1-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/C3251332-A869-4C6C-A2B9-E1E48E84A538-1.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><\/p>\n<p>Microsoft Excel, a powerful and widely-used <a class=\"wpil_keyword_link\" title=\"spreadsheet\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-excel-templates-and-spreadsheets\/\" target=\"_blank\" rel=\"noopener\" data-wpil-keyword-link=\"linked\">spreadsheet<\/a> software, offers a plethora of functions to assist users in <strong>managing and analyzing data<\/strong> effectively. Among these functions, the <strong>MATCH function stands out as a valuable tool<\/strong> to all users.<\/p>\n<p>Whether you&#8217;re<strong> working on simple <a class=\"wpil_keyword_link\" title=\"data entry\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/create-data-entry-form-excel\/\" target=\"_blank\" rel=\"noopener\" data-wpil-keyword-link=\"linked\">data entry<\/a> tasks or complex data analysis projects<\/strong>, understanding how to use the MATCH function can <strong>significantly enhance your efficiency and accuracy<\/strong>.<\/p>\n<p>In this article, we will cover the following topics in detail &#8211;<\/p>\n<p>Download the Excel Workbook below to follow along and understand how to use the MATCH function in Excel \u2013<\/p>\n<p><a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-in-Excel.xlsx\" target=\"_blank\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel workbook<\/strong><\/span><span class=\"postTitle px-3\">MATCH-Function-in-Excel.xlsx<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span id=\"1\" style=\"color: #ff0000\">Introduction to MATCH function<\/span><\/strong><\/p>\n<p>The MATCH function in Excel can be used to <strong>locate the position of a lookup value<\/strong> in a row, column, or table. This can be useful when you have a <strong>large dataset and need to find the exact position of a certain value<\/strong>, such as when you&#8217;re looking for a particular product in an inventory list or trying to match a name to an employee ID.<\/p>\n<p>The <strong>syntax<\/strong> of the MATCH function is &#8211;<\/p>\n<p><strong>=MATCH(lookup_value, lookup_array, [match_type])<\/strong><\/p>\n<ul>\n<li><b class=\"ocpRunInHead\">lookup_value &#8211;<\/b> The value that you want to match in the lookup array. It can be a value (number, text, or logical value) or a cell reference to a number, text, or logical value. <strong>Required<\/strong>.<\/li>\n<li><b class=\"ocpRunInHead\">lookup_array<\/b> &#8211; The range of cells being searched. <strong>Required<\/strong>.<\/li>\n<li><b class=\"ocpRunInHead\">match_type &#8211; <\/b>It specifies the match type. <strong><em>Optional<\/em><\/strong>.\n<ul>\n<li><strong>1<\/strong>: Finds an exact match or the next smallest value. The lookup_array needs to be sorted in ascending order (Default).<\/li>\n<li><strong>0<\/strong>: Finds an exact match for the lookup_value.<\/li>\n<li><strong>-1<\/strong>: Finds an exact match or the next largest value. The lookup_array needs to be sorted in descending order.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong><span id=\"2\" style=\"color: #ff0000\">Exact Match<\/span><\/strong><\/p>\n<p>Imagine you have a Product List and seek to determine the position of a specific item within this list. In such a scenario, the MATCH function would come into play.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-8.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30638\" title=\"Unlock the Power of the MATCH Function - Top 3 Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-8.png\" alt=\"Unlock the Power of the MATCH Function - Top 3 Examples\" width=\"690\" height=\"477\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-8.png 690w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-8-300x207.png 300w\" sizes=\"(max-width: 690px) 100vw, 690px\" \/><\/a><\/p>\n<p>Let&#8217;s use the MATCH function to determine the position of the Laptop in the list provided.<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1:<\/strong><\/span> Enter the MATCH function.<\/p>\n<p><strong>=MATCH(<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-9.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30639\" title=\"Unlock the Power of the MATCH Function - Top 3 Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-9.png\" alt=\"Unlock the Power of the MATCH Function - Top 3 Examples\" width=\"767\" height=\"473\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-9.png 767w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-9-300x185.png 300w\" sizes=\"(max-width: 767px) 100vw, 767px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong><\/span> Enter the first argument i.e. lookup_value. Here, it is Laptop mentioned in cell D1.<\/p>\n<p><strong>=MATCH(D1,\u00a0<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-10.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30640\" title=\"Unlock the Power of the MATCH Function - Top 3 Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-10.png\" alt=\"Unlock the Power of the MATCH Function - Top 3 Examples\" width=\"683\" height=\"478\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-10.png 683w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-10-300x210.png 300w\" sizes=\"(max-width: 683px) 100vw, 683px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong><\/span> Enter the second argument i.e. lookup_array. Here, it is mentioned in cell A2:A16.<\/p>\n<p><strong>=MATCH(D1,A2:A16,<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-11.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30641\" title=\"Unlock the Power of the MATCH Function - Top 3 Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-11.png\" alt=\"Unlock the Power of the MATCH Function - Top 3 Examples\" width=\"769\" height=\"495\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-11.png 769w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-11-300x193.png 300w\" sizes=\"(max-width: 769px) 100vw, 769px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 4:<\/strong><\/span> Enter the second argument i.e. match_type. Here, it is 0 for an exact match.<\/p>\n<p><strong>=MATCH(D1,A2:A16,0)<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-12.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30642\" title=\"Unlock the Power of the MATCH Function - Top 3 Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-12.png\" alt=\"Unlock the Power of the MATCH Function - Top 3 Examples\" width=\"606\" height=\"484\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-12.png 606w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-12-300x240.png 300w\" sizes=\"(max-width: 606px) 100vw, 606px\" \/><\/a><\/p>\n<p>The position of the Laptop is 2 in the list.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-13.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30643\" title=\"Unlock the Power of the MATCH Function - Top 3 Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-13.png\" alt=\"Unlock the Power of the MATCH Function - Top 3 Examples\" width=\"530\" height=\"466\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-13.png 530w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-13-300x264.png 300w\" sizes=\"(max-width: 530px) 100vw, 530px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span id=\"3\" style=\"color: #ff0000\">Approximate Match<\/span><\/strong><\/p>\n<p>For an approximate match search, you must<strong> configure the match_type to either 1 (exact match or nearest smaller value) or -1 (exact match or nearest smaller value).<\/strong><\/p>\n<ul>\n<li>If you need an exact match or <strong>nearest smaller value<\/strong>; you need to sort the data in <strong>ascending order<\/strong>.<\/li>\n<li>If you need an exact match or <strong>nearest larger value<\/strong>; you need to sort the data in <strong>descending order<\/strong>.<\/li>\n<\/ul>\n<p>The approximate match is useful when you have <strong>a range of values representing sales figures and you want to find the position of the highest value that&#8217;s less than or equal to a certain target<\/strong>.<\/p>\n<p>In the example shown below, there is a range of values representing sales figures and you want to find the position of the highest value that&#8217;s less than or equal to a certain target. We need to know the <strong>position of sales amount &#8211; $12,000 <\/strong>with the help of the Match function.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30687\" title=\"Unlock the Power of the MATCH Function - Top 3 Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-1.png\" alt=\"Unlock the Power of the MATCH Function - Top 3 Examples\" width=\"516\" height=\"289\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-1.png 516w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-1-300x168.png 300w\" sizes=\"(max-width: 516px) 100vw, 516px\" \/><\/a><\/p>\n<p>Follow the steps below to achieve the results &#8211;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1:<\/strong><\/span> Enter the MATCH function.<\/p>\n<p><strong>=MATCH(<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-2-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30650\" title=\"Unlock the Power of the MATCH Function - Top 3 Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-2-1.png\" alt=\"Unlock the Power of the MATCH Function - Top 3 Examples\" width=\"747\" height=\"292\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-2-1.png 747w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-2-1-300x117.png 300w\" sizes=\"(max-width: 747px) 100vw, 747px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong><\/span> Enter the first argument i.e. lookup_value. Here, it is Laptop mentioned in cell D1.<\/p>\n<p><strong>=MATCH(D1,\u00a0<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-3-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30651\" title=\"Unlock the Power of the MATCH Function - Top 3 Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-3-1.png\" alt=\"Unlock the Power of the MATCH Function - Top 3 Examples\" width=\"682\" height=\"286\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-3-1.png 682w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-3-1-300x126.png 300w\" sizes=\"(max-width: 682px) 100vw, 682px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong><\/span> Enter the second argument i.e. lookup_array. Here, it is mentioned in cell A2:A16.<\/p>\n<p><strong>=MATCH(D1,A2:A8,<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-4-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30652\" title=\"Unlock the Power of the MATCH Function - Top 3 Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-4-1.png\" alt=\"Unlock the Power of the MATCH Function - Top 3 Examples\" width=\"666\" height=\"310\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-4-1.png 666w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-4-1-300x140.png 300w\" sizes=\"(max-width: 666px) 100vw, 666px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 4:<\/strong><\/span> Enter the second argument i.e. match_type. Here, it is 1 as we need to know the position for an exact match or the next smaller.<\/p>\n<p><strong>=MATCH(D1,A2:A8,1)<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-5-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30653\" title=\"Unlock the Power of the MATCH Function - Top 3 Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-5-1.png\" alt=\"Unlock the Power of the MATCH Function - Top 3 Examples\" width=\"575\" height=\"288\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-5-1.png 575w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-5-1-300x150.png 300w\" sizes=\"(max-width: 575px) 100vw, 575px\" \/><\/a><\/p>\n<p>Since the next smallest value for 12,000 is 10,000; Excel has displayed the result as the position of 10000 i.e. 4.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-6-2.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30657\" title=\"Unlock the Power of the MATCH Function - Top 3 Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-6-2.png\" alt=\"Unlock the Power of the MATCH Function - Top 3 Examples\" width=\"589\" height=\"289\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-6-2.png 589w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-6-2-300x147.png 300w\" sizes=\"(max-width: 589px) 100vw, 589px\" \/><\/a><\/p>\n<p>Now, if we want to <strong>search for the next largest value, replace the third argument with -1<\/strong>. Here, since the next larger value is 50000, Excel has displayed the position of 50000 i.e. 3.<\/p>\n<p><strong>=MATCH(D1,A2:A8,-1)<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-7-2.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30656\" title=\"Unlock the Power of the MATCH Function - Top 3 Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-7-2.png\" alt=\"Unlock the Power of the MATCH Function - Top 3 Examples\" width=\"518\" height=\"280\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-7-2.png 518w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-7-2-300x162.png 300w\" sizes=\"(max-width: 518px) 100vw, 518px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span id=\"4\" style=\"color: #ff0000\">Wildcard MATCH<\/span><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/filter-by-text-wildcards\/\" target=\"_blank\"><strong>Wildcards<\/strong><\/a> in Excel are special characters that you can <strong>use as placeholders\u00a0to represent one or more characters<\/strong> in a text string. It can be used when you are <strong>unsure about the exact characters present at a specific location<\/strong>.<\/p>\n<p>There are two main wildcards used in Excel:<\/p>\n<ol>\n<li><strong>Asterisk (*)<\/strong> &#8211; The asterisk wildcard represents any sequence of characters, including no characters. For example:\n<ul>\n<li>&#8220;app*&#8221; can match &#8220;apple,&#8221; &#8220;application,&#8221; &#8220;approve,&#8221; etc.<\/li>\n<li>&#8220;*ing&#8221; can match &#8220;singing,&#8221; &#8220;running,&#8221; &#8220;writing,&#8221; etc.<\/li>\n<\/ul>\n<\/li>\n<li><strong>Question Mark (?)<\/strong> &#8211; The question mark wildcard represents any single character. For example:\n<ul>\n<li>&#8220;h?t&#8221; can match &#8220;hat,&#8221; &#8220;hot,&#8221; &#8220;hit,&#8221; etc.<\/li>\n<li>&#8220;?it&#8221; can match &#8220;sit&#8221;, &#8220;hit&#8221;, etc.<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<p>Let us look at an example to understand how to use wildcards in <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/xmatch-function-2\/\" target=\"_blank\" rel=\"noopener\">the MATCH function<\/a> in Excel.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-20.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30680\" title=\"Unlock the Power of the MATCH Function - Top 3 Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-20.png\" alt=\"Unlock the Power of the MATCH Function - Top 3 Examples\" width=\"605\" height=\"501\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-20.png 605w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-20-300x248.png 300w\" sizes=\"(max-width: 605px) 100vw, 605px\" \/><\/a><\/p>\n<p>Here, we want to know the position of the product name starting with C.<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1:<\/strong><\/span> Enter the MATCH function.<\/p>\n<p><strong>=MATCH(<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-22.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30682\" title=\"Unlock the Power of the MATCH Function - Top 3 Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-22.png\" alt=\"Unlock the Power of the MATCH Function - Top 3 Examples\" width=\"771\" height=\"501\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-22.png 771w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-22-300x195.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-22-768x499.png 768w\" sizes=\"(max-width: 771px) 100vw, 771px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong><\/span> Enter the first argument i.e. lookup_value. Here, it is &#8220;C*&#8221; mentioned in cell D1.<\/p>\n<p><strong>=MATCH(D1,\u00a0<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-16.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30646\" title=\"Unlock the Power of the MATCH Function - Top 3 Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-16.png\" alt=\"Unlock the Power of the MATCH Function - Top 3 Examples\" width=\"769\" height=\"474\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-16.png 769w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-16-300x185.png 300w\" sizes=\"(max-width: 769px) 100vw, 769px\" \/><\/a><\/p>\n<p>By incorporating asterisks behind the letter C, the function searches for any product name starting with the letter C.<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong><\/span> Enter the second argument i.e. lookup_array. Here, it is mentioned in cell A2:A16.<\/p>\n<p><strong>=MATCH(D1,A2:A16,<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-17.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30647\" title=\"Unlock the Power of the MATCH Function - Top 3 Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-17.png\" alt=\"Unlock the Power of the MATCH Function - Top 3 Examples\" width=\"687\" height=\"495\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-17.png 687w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-17-300x216.png 300w\" sizes=\"(max-width: 687px) 100vw, 687px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 4:<\/strong><\/span> Enter the second argument i.e. match_type. Here, it is 0 for an exact match.<\/p>\n<p><strong>=MATCH(D1,A2:A16,0)<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-18.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30648\" title=\"Unlock the Power of the MATCH Function - Top 3 Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-18.png\" alt=\"Unlock the Power of the MATCH Function - Top 3 Examples\" width=\"610\" height=\"481\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-18.png 610w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-18-300x237.png 300w\" sizes=\"(max-width: 610px) 100vw, 610px\" \/><\/a><\/p>\n<p>Here is the result!<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-21.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30681\" title=\"Unlock the Power of the MATCH Function - Top 3 Examples\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-21.png\" alt=\"Unlock the Power of the MATCH Function - Top 3 Examples\" width=\"530\" height=\"510\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-21.png 530w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/08\/MATCH-Function-21-300x289.png 300w\" sizes=\"(max-width: 530px) 100vw, 530px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000\">Conclusion<\/span><\/strong><\/p>\n<p>The <strong>MATCH<\/strong> function in Excel is a powerful tool that allows you to search for a specified value in a range of cells and returns the relative position of that value within the range. From exact, approximate, to wildcard matches, MATCH empowers users to locate data points precisely and adapt to dynamic patterns.<\/p>\n<p><strong>Further Learning:<\/strong><\/p>\n<ul>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/index-and-match-made-simple\/\" target=\"_blank\" rel=\"noopener\">INDEX and MATCH Made Simple<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/match-two-lists-with-the-match-function-in-excel\/\" target=\"_blank\" rel=\"noopener\">Match Two Lists With The MATCH Function<\/a><\/li>\n<li><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/index-match-maximum-sales-in-excel\/\" target=\"_blank\" rel=\"noopener\">INDEX-MATCH Maximum Sales<\/a><\/li>\n<\/ul>\n<p><a href=\"https:\/\/support.microsoft.com\/en-au\/office\/match-function-e8dffd45-c762-47d6-bf89-533f4a37673a#:~:text=The%20MATCH%20function%20searches%20for,second%20item%20in%20the%20range.\" target=\"_blank\" rel=\"nofollow noopener\"><strong>Click here<\/strong><\/a> to learn all about it!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Microsoft Excel, a powerful and widely-used spreadsheet software, offers a plethora of functions to assist users in managing and analyzing data effectively. Among these functions, the MATCH function stands out as a valuable tool to all users. Whether you&#8217;re working on simple data entry tasks or complex data analysis projects, understanding how to use the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":30670,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[11,280],"tags":[1338,1339,1337],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/30621"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=30621"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/30621\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/30670"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=30621"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=30621"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=30621"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}