{"id":1643,"date":"2022-12-13T20:52:38","date_gmt":"2022-12-13T20:52:38","guid":{"rendered":"https:\/\/www.bizinfograph.com\/resource\/?p=1643"},"modified":"2024-02-19T18:01:58","modified_gmt":"2024-02-19T18:01:58","slug":"how-to-use-index-and-match-functions-in-excel","status":"publish","type":"post","link":"https:\/\/www.bizinfograph.com\/resource\/how-to-use-index-and-match-functions-in-excel\/","title":{"rendered":"How to use INDEX and MATCH Functions in Excel? With Multiple Criteria."},"content":{"rendered":"<p>INDEX and MATCH functions in Excel are powerful tools for performing lookups and retrieving data from a table or range.\u00a0 Excel is a powerful tool that offers a wide range of functions to help us manipulate and analyze data effectively. Among these functions, INDEX and MATCH stand out as a dynamic duo, capable of performing complex lookups and retrieving specific information from large datasets. Whether you&#8217;re a beginner or an experienced Excel user, mastering the INDEX and MATCH functions can significantly enhance your data analysis skills.<\/p>\n<p><strong>This Tutorial Covers:<\/strong><\/p>\n<ol>\n<li><a href=\"#the-basics-of-index-and-match-function\">The Basics of INDEX and MATCH Function<\/a>\n<ul>\n<li>INDEX Function<\/li>\n<li>MATCH Function<\/li>\n<li>INDEX and MATCH Function Together<\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#how-to-use-index-and-match-function-in-excel\">How to Use INDEX and MATCH Function in Excel<\/a>\n<ul>\n<li>Two-way lookup<\/li>\n<li>Left lookup<\/li>\n<li>Case-sensitive lookup<\/li>\n<li>Closest Match<\/li>\n<li>Multiple criteria lookup<\/li>\n<li>INDEX MATCH with MAX, MIN and AVERAGE<\/li>\n<li>INDEX MATCH with IFNA \/ IFERROR<\/li>\n<\/ul>\n<\/li>\n<li><a href=\"#index-match-vs-vlookup\">INDEX MATCH vs VLOOKUP<\/a><\/li>\n<\/ol>\n<h2><strong id=\"the-basics-of-index-and-match-function\">1. The Basics of INDEX and MATCH Function<\/strong><\/h2>\n<h3><strong>1.1 INDEX Function<\/strong><\/h3>\n<p>You&#8217;ll find the Excel INDEX function in a vast variety of calculations, especially complex formulas. It is highly customizable and powerful. A value at a designated area in a range can be obtained via INDEX.<\/p>\n<p>Below you have a table which contains the name list of 5 salesmen. Now use the formula below<\/p>\n<p>to get the name of the 3<sup>rd<\/sup> salesman.<\/p>\n<p><strong>=INDEX(B4:B8,3)<\/strong><\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter size-full wp-image-1644\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-1.png\" alt=\"INDEX and MATCH Functions\" width=\"650\" height=\"260\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-1.png 650w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-1-300x120.png 300w\" sizes=\"(max-width: 650px) 100vw, 650px\" \/><\/p>\n<p>You can also retrieve the information about the sales status for 3<sup>rd<\/sup> salesman in May using the rows and columns information in Index formula.<\/p>\n<p><strong>=INDEX(B4:E8,3,3)<\/strong><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-1645\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-2.png\" alt=\"INDEX and MATCH Functions\" width=\"650\" height=\"263\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-2.png 650w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-2-300x121.png 300w\" sizes=\"(max-width: 650px) 100vw, 650px\" \/><\/p>\n<h3><strong>1.2 MATCH Function<\/strong><\/h3>\n<p>Finding an item&#8217;s location in a range is the only thing the MATCH function is intended to do. The location of a value inside a specified range is returned by the MATCH function. Using the Match function, you can acquire data about any salesman\u2019s position on the spreadsheet.<\/p>\n<p><strong>=MATCH(&#8220;James&#8221;,B4:B8,0)<\/strong><\/p>\n<p><img decoding=\"async\" class=\"aligncenter size-full wp-image-1646\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-3.png\" alt=\"INDEX and MATCH Functions\" width=\"632\" height=\"224\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-3.png 632w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-3-300x106.png 300w\" sizes=\"(max-width: 632px) 100vw, 632px\" \/><\/p>\n<h3><strong>1.3 INDEX and MATCH Function Together<\/strong><\/h3>\n<p>Using the Index function, you have gathered the information about the 3<sup>rd<\/sup> seller Albert and how much he sold in February using the data from both row and column. The Match function provided you with information about a particular seller\u2019s serial number. Now you can very easily combine Index and Match function in a single formula and gather the information about how much the 5<sup>th<\/sup> seller sold in June following the picture below.<\/p>\n<p><strong>=INDEX(C4:E8,MATCH(&#8220;Stuart&#8221;,B4:B8,0),3)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1647\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-4.png\" alt=\"INDEX and MATCH Functions\" width=\"624\" height=\"258\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-4.png 624w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-4-300x124.png 300w\" sizes=\"(max-width: 624px) 100vw, 624px\" \/><\/p>\n<p><span style=\"color: #0000ff;\">Also Read: <a href=\"https:\/\/www.bizinfograph.com\/resource\/how-to-use-xlookup-in-excel\/\" target=\"_blank\" rel=\"noopener\"><em><span style=\"text-decoration: underline;\"><span style=\"color: #3366ff; text-decoration: underline;\">How to use XLOOKUP in Excel?<\/span><\/span><\/em><\/a><\/span><\/p>\n<h2><strong id=\"how-to-use-index-and-match-function-in-excel\">2. How to Use INDEX and MATCH Functions in Excel<\/strong><\/h2>\n<p>In this tutorial, we have seen how the Index and Match function work separately and how can we combine them in a single formula to make our work easier and quicker. There are a variety of uses of the Index Match function in Excel. Now we will learn about the uses of the Index and Match Functions in a detailed manner.<\/p>\n<h3><strong>2.1 Two-way lookup <\/strong><\/h3>\n<p>Using Index and Match we can execute a Two-Way lookup. From the table below you can acquire information about any seller\u2019s sell data of April, May and June. Here you will use the 4<sup>th<\/sup> seller James and gather his sells data for these three months.<\/p>\n<p><strong>Step 1: <\/strong>Type or paste the formula in cell H4 and click <strong>Enter. <\/strong>You will get the sells data of James from April.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1648\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-5.png\" alt=\"INDEX and MATCH Functions\" width=\"650\" height=\"212\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-5.png 650w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-5-300x98.png 300w\" sizes=\"(max-width: 650px) 100vw, 650px\" \/><\/p>\n<p><strong>Step 2: <\/strong>Now paste the formula in the other two cells under May and June or simply just drag the data from H4 to J4 to get the sales data of the other two months using the same Index and Match formula.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1649\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-6.png\" alt=\"INDEX and MATCH Functions\" width=\"652\" height=\"239\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-6.png 652w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-6-300x110.png 300w\" sizes=\"(max-width: 652px) 100vw, 652px\" \/><\/p>\n<p>The Index formula here used from cell C4 to E8 as a range that has all the sales data from each month of every seller and the first MATCH retrieves the name&#8217;s location in the name\u2019s column using the name (James in cell G4) (B4:B8).<\/p>\n<p>The month name (in cell H3) is used in the second MATCH formula\u00a0to determine where that particular subject name is located in the range C3:E3. For instance, April ranks first, May second, and June third. Since the INDEX function receives these MATCH locations as input, it outputs the score based on the seller\u2019s name and month name. Now if you want to know the data of any other seller simply just type the name of that seller instead of James in cell G4.<\/p>\n<h3><strong>2.2 Left lookup<\/strong><\/h3>\n<p>The capability of\u00a0performing\u00a0a &#8220;left lookup&#8221; is one of the primary advantages of INDEX and MATCH function. Using Index and Match function you can retrieve the total sales data for any particular seller while the sale data is on the left of the seller.<\/p>\n<p>Select the cell below Bob\u2019s Total sale and type or paste the formula shown in the picture. Click Enter.<\/p>\n<p><strong>=INDEX($B$4:$C$8,MATCH(&#8220;Bob&#8221;,C4:C8,0),1)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1650\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-7.png\" alt=\"INDEX and MATCH Functions\" width=\"629\" height=\"302\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-7.png 629w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-7-300x144.png 300w\" sizes=\"(max-width: 629px) 100vw, 629px\" \/><\/p>\n<p>The Index formula uses from cell B4 to C8 as it\u2019s range. The Match formula uses the name Bob to locate its location in range C4 to C8 to retrieve Bob\u2019s sales data from Total sale\u2019s column.<\/p>\n<h3><strong>2.3 Case-sensitive lookup<\/strong><\/h3>\n<p>The MATCH function is not case-sensitive on its own. But, to execute a lookup that takes into account both upper- and lowercase letters, you can\u00a0combine the EXACT function with INDEX and MATCH. When there is a chance of repetition or distinct names in huge data sets, with the case being a major distinction, you have to apply this method to get your desired data.<\/p>\n<p><strong>Step 1:<\/strong> Select the cell under Sale and type or paste the formula shown in the picture.<\/p>\n<p><strong>=INDEX(C3:C7,MATCH(TRUE,EXACT(E3,B3:B7),0),1)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1651\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-8.png\" alt=\"INDEX and MATCH Functions\" width=\"650\" height=\"245\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-8.png 650w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-8-300x113.png 300w\" sizes=\"(max-width: 650px) 100vw, 650px\" \/><\/p>\n<p><strong>Step 2:<\/strong> Use <strong>CTRL+SHIFT+ENTER<\/strong> command key to because this is an array formula and only Enter will not work here.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1652\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-9.png\" alt=\"INDEX and MATCH Functions\" width=\"650\" height=\"276\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-9.png 650w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-9-300x127.png 300w\" sizes=\"(max-width: 650px) 100vw, 650px\" \/><\/p>\n<h3><strong>2.4 Closest Match<\/strong><\/h3>\n<p>Use the Excel functions INDEX, MATCH, ABS, and MIN to discover the data in a column that matches a target value the closest.<\/p>\n<p>Use the below-given formula in the cell under the target value and use <strong>CTRL+SHIFT+ENTER<\/strong> command key to because this is an array formula. By this method, you can extract the closest match to your target value.<\/p>\n<p><strong>=INDEX(B3:B7,MATCH(MIN(ABS(C3:C7-F2)),ABS(C3:C7-F2),0))<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1653\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-10.png\" alt=\"INDEX and MATCH Functions\" width=\"651\" height=\"260\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-10.png 651w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-10-300x120.png 300w\" sizes=\"(max-width: 651px) 100vw, 651px\" \/><\/p>\n<p><span style=\"color: #0000ff;\">Also Read: <a href=\"https:\/\/www.bizinfograph.com\/resource\/how-to-do-a-picture-lookup-in-excel\/\" target=\"_blank\" rel=\"noopener\"><em><span style=\"text-decoration: underline;\"><span style=\"color: #3366ff; text-decoration: underline;\">How to a Picture Lookup in Excel?<\/span><\/span><\/em><\/a><\/span><\/p>\n<h3><strong>2.5 Multiple criteria lookup<\/strong><\/h3>\n<p>A lookup, based on multiple criteria is among the toughest issues in Excel. In other words, a search that simultaneously matches values from many columns is a very complicated issue while using the Index Match function. But by utilizing INDEX, MATCH, and Boolean logic it is possible to derive data from these types of columns.<\/p>\n<p>Use the following formula in the cell on the right of <strong>Price <\/strong>and Use <strong>CTRL+SHIFT+ENTER<\/strong> command key. This will show you the price of your desired item.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1654\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-11.png\" alt=\"INDEX and MATCH Functions\" width=\"652\" height=\"348\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-11.png 652w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-11-300x160.png 300w\" sizes=\"(max-width: 652px) 100vw, 652px\" \/><\/p>\n<h3><strong>2.6 INDEX MATCH with MAX, MIN, and AVERAGE<\/strong><\/h3>\n<p>In order to identify the minimum, maximum, and average values inside a range, Microsoft Excel provides unique functions. You can execute this by combining INDEX MATCH with the MAX, MIN, or AVERAGE functions.<\/p>\n<p><strong>Step 1:<\/strong> To find out the minimum amount from the Total sales column and who made the lowest sales, use the combined formula of INDEX MATCH and MIN and click Enter.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1655\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-12.png\" alt=\"INDEX and MATCH Functions\" width=\"623\" height=\"303\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-12.png 623w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-12-300x146.png 300w\" sizes=\"(max-width: 623px) 100vw, 623px\" \/><\/p>\n<p><strong>Step 2:<\/strong> Use the combined formula of INDEX MATCH and MAX and press Enter to determine the maximum amount from the Total sales column and who made the highest sales.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1656\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-13.png\" alt=\"INDEX and MATCH Functions\" width=\"641\" height=\"273\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-13.png 641w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-13-300x128.png 300w\" sizes=\"(max-width: 641px) 100vw, 641px\" \/><\/p>\n<p><strong>Step 3:<\/strong> Use the combined INDEX MATCH and AVERAGE formula and press Enter to determine the average of Total sales as well as the seller who made the average sales.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1657\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-14.png\" alt=\"INDEX and MATCH Functions\" width=\"612\" height=\"255\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-14.png 612w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-14-300x125.png 300w\" sizes=\"(max-width: 612px) 100vw, 612px\" \/><\/p>\n<h3><strong>2.7 INDEX MATCH with IFNA \/ IFERROR<\/strong><\/h3>\n<p><strong>Step 1: <\/strong>Excel&#8217;s INDEX MATCH formula generates a #N\/A error if it is unable to locate a lookup value. Wrap your INDEX MATCH formula in the IFNA function if you want to replace the usual error notation with something more relevant.<\/p>\n<p><strong>=IFNA(INDEX(B2:B5,MATCH(F1,A2:A5,0)), &#8220;No match found&#8221;)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1658\" src=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-15.png\" alt=\"INDEX and MATCH Functions\" width=\"651\" height=\"214\" srcset=\"https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-15.png 651w, https:\/\/www.bizinfograph.com\/resource\/wp-content\/uploads\/2022\/12\/INDEX-and-MATCH-Functions-15-300x99.png 300w\" sizes=\"(max-width: 651px) 100vw, 651px\" \/><\/p>\n<p>Use the IFERROR function rather than IFNA if you want to capture all errors instead of just #N\/A.<\/p>\n<p><strong>= IFERROR(INDEX(B2:B5,MATCH(F1,A2:A5,0)), &#8220;<\/strong> <strong>Oops, something went wrong! &#8220;)<\/strong><\/p>\n<h2><strong id=\"index-match-vs-vlookup\">3. INDEX MATCH vs VLOOKUP<\/strong><\/h2>\n<p>INDEX MATCH function and VLOOKUP both are very useful while retrieving complex data from a worksheet. Here you will see a brief comparison between both options for your better judgment in deciding which method to use to make your work more efficient and less time-consuming.<\/p>\n<ol>\n<li>The first disadvantage of VLOOKUP is that it can\u2019t look to its left so the table&#8217;s leftmost column should always contain your lookup value. On the other hand, INDEZ MATCH can do it very efficiently.<\/li>\n<li>The only viable option if your dataset contains lengthy strings is INDEX MATCH because the total number of characters in your search criteria cannot exceed 255 when using the VLOOKUP function; otherwise, the #VALUE! The error will occur.<\/li>\n<li>MATCH INDEX will perform significantly more quickly than VLOOKUP if your worksheets include hundreds or thousands of rows, and consequently hundreds or thousands of formulas since Excel will only need to process the lookup and return columns rather than the complete table array.<\/li>\n<li>If your worksheet contains sophisticated array formulae like VLOOKUP and SUM, the influence of VLOOKUP on Excel&#8217;s performance may be more apparent. This situation will require VLOOKUP Function and INDEZ MATCH won\u2019t be of any use here.<\/li>\n<li>When a new column is removed from or added to a lookup table, VLOOKUP formulae become unusable or produce inaccurate results. On the other hand, you give the return column range rather than an index number when using INDEX MATCH. As a result, you are free to add and remove as many columns as you like without having to worry about modifying each formula that is connected with them.<\/li>\n<\/ol>\n<p>For ready-to-use Dashboard Templates:<\/p>\n<ol>\n<li style=\"list-style-type: none;\">\n<ol>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Finance\" target=\"_blank\" rel=\"noopener\">Financial Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Sales\" target=\"_blank\" rel=\"noopener\">Sales Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.bizinfograph.com\/dashboard-templates#Human-Resource\" target=\"_blank\" rel=\"noopener\">HR Dashboards<\/a><\/li>\n<li><a href=\"https:\/\/www.executiveknowledge.org\/dashboard-templates\/35\" target=\"_blank\" rel=\"noopener\">Data Visualization Charts<\/a><\/li>\n<\/ol>\n<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>INDEX and MATCH functions in Excel are powerful tools for performing lookups and retrieving data from a table or range.\u00a0 Excel is a powerful tool that offers a wide range of functions to help us manipulate and analyze data effectively. Among these functions, INDEX and MATCH stand out as a dynamic duo, capable of performing &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.bizinfograph.com\/resource\/how-to-use-index-and-match-functions-in-excel\/\"> <span class=\"screen-reader-text\">How to use INDEX and MATCH Functions in Excel? With Multiple Criteria.<\/span> Read More &raquo;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","footnotes":""},"categories":[237],"tags":[239,238],"class_list":["post-1643","post","type-post","status-publish","format-standard","hentry","category-index-and-match-functions","tag-index-and-match-functions","tag-index-and-match-functions-in-excel"],"_links":{"self":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/1643","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/comments?post=1643"}],"version-history":[{"count":9,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/1643\/revisions"}],"predecessor-version":[{"id":8644,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/posts\/1643\/revisions\/8644"}],"wp:attachment":[{"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/media?parent=1643"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/categories?post=1643"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bizinfograph.com\/resource\/wp-json\/wp\/v2\/tags?post=1643"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}