{"id":262946,"date":"2024-03-13T20:07:24","date_gmt":"2024-03-13T19:07:24","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=262946"},"modified":"2026-10-21T16:03:15","modified_gmt":"2026-10-21T14:03:15","slug":"index-match-varios-criterios-google-sheets","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/google-sheets-formulas\/index-match-multiple-criteria\/","title":{"rendered":"Como usar INDEX MATCH com v\u00e1rios crit\u00e9rios no Google Sheets"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221; da_disable_devices=&#8221;off|off|off&#8221;][et_pb_row admin_label=&#8221;row&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Spreadsheet programs like Microsoft Excel and Google Sheets offer various functions designed to look up values in your tables. Both offer HLOOKUP and <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-formulas\/vlookup-importrange\/\" rel=\"noreferrer noopener\" target=\"_blank\">VLOOKUP<\/a> for horizontal and vertical lookups, as well as <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/how-to-use-xlookup-in-google-sheets-formulas-and-examples\/\" rel=\"noreferrer noopener\" target=\"_blank\">XLOOKUP<\/a>, which combines them and provides more flexibility. However, using them with multiple criteria can be very tricky, as it requires various levels of nesting. Fortunately, combining the INDEX &amp; MATCH functions allows you to perform flexible and complex lookups using multiple criteria.<\/p>\n<p>In this guide, you will first review the INDEX and MATCH functions and how to combine them for lookups. You will then learn how a small adjustment allows you to use multiple criteria for your lookups, whether vertical, horizontal, or mixed. You have step-by-step instructions on how to look up values using multiple criteria for a horizontal lookup, a vertical lookup, and one with both horizontal and vertical criteria. Finally, you will learn how to combine INDEX &amp; MATCH with other functions, like AVERAGE.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;index-match-function-syntax&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>INDEX &amp; MATCH function syntax<\/h2>\n<p>Before you get started with lookups based on multiple criteria, it\u2019s a good idea to review the syntax for both functions, as well as the combined syntax.<\/p>\n<blockquote>\n<p>=INDEX(reference, row*, column*)<\/p>\n<\/blockquote>\n<ul>\n<li><strong>reference:<\/strong> the range of cells from which you want the values returned.<\/li>\n<li><strong>row*:<\/strong> optional. The index of the row to be returned within the reference range of cells. 0 by default. This is where you add MATCH for vertical lookups.<\/li>\n<li><strong>column*:<\/strong> optional. The index of the column to be returned within the reference range of cells. 0 by default. This is where you add MATCH for horizontal lookups.<\/li>\n<\/ul>\n<blockquote>\n<p>=MATCH(search_key, range, search_type*)<\/p>\n<\/blockquote>\n<ul>\n<li><strong>search_key:<\/strong> the value you want to search for.<\/li>\n<li><strong>range:<\/strong> the one-dimensional array in which to search.<\/li>\n<li><strong>search_type*:<\/strong> optional. The manner in which to search.\n<ul>\n<li><strong>1<\/strong> is the default. The function assumes the range is in ascending order and returns the largest value less than or equal to the search key.<\/li>\n<li><strong>0<\/strong> finds an exact match. The range does not need to be sorted.<\/li>\n<li><strong>-1<\/strong> assumes the range is in descending order and returns the smallest value greater than or equal to the search key.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;index-match-combined-syntax&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>INDEX &amp; MATCH combined syntax<\/h2>\n<p>To use the INDEX function, you need to specify the row and column in your range. The function then returns the contents of the cell where the row and column intersect. In other words, you need to provide the coordinates or cell references.<\/p>\n<p>The MATCH function, on the other hand, searches for a specific value and returns the coordinates or cell reference. In fact, it\u2019s exactly what you need to make the INDEX function dynamic. As indicated above, you can replace the row and column arguments in INDEX with MATCH functions.<\/p>\n<blockquote>\n<p>=INDEX(range,MATCH(search_key,search_column,search_type),MATCH(search_key,search_row,search_type))<\/p>\n<\/blockquote>\n<p>Using the formula above, you can specify the row and column criterion for your lookup, but you\u2019re limited to one of each. Fortunately, you can change this by making a small adjustment to the formula.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;combined-syntax-for-lookups-with-multipl&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Combined syntax for lookups with multiple criteria<\/h2>\n<p>Within the MATCH function, you can replace the search_key with \u201c1\u201d and the search_column or search_row with a set of criteria or conditions. Each of these conditions must be within parentheses and joined by a multiplication sign. This forces the function to evaluate each condition and only return \u201c1\u201d if all conditions are met.<\/p>\n<h3>Vertical lookup with multiple criteria<\/h3>\n<p>Use the following formula for a vertical lookup with multiple criteria.<\/p>\n<blockquote>\n<p>=INDEX(reference,MATCH(1,(criteria1)*(criteria2)*(criteriaN),0))<\/p>\n<\/blockquote>\n<h3>Horizontal lookup with multiple criteria<\/h3>\n<p>Use the following formula for a horizontal lookup with multiple criteria.<\/p>\n<blockquote>\n<p>=INDEX(reference,row,MATCH(1,(criteria1)*(criteria2)*(criteriaN),0))<\/p>\n<\/blockquote>\n<h3>Vertical &amp; horizontal lookup with multiple criteria<\/h3>\n<p>Use the following formula for a lookup with multiple vertical and horizontal criteria.<\/p>\n<blockquote>\n<p>=INDEX(reference,MATCH(1,(criteria1)*(criteria2)*(criteriaN),0),MATCH(1,(criteria1)*(criteria2)*(criteriaN),0))<\/p>\n<\/blockquote>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;how-to-use-index-match-with-multiple-cri&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to use INDEX &amp; MATCH with multiple criteria in Google Sheets<\/h2>\n<p>Combining the INDEX &amp; MATCH functions allows you to perform lookups by matching values using multiple criteria. In other words, it allows you to disambiguate in cases where there are multiple potential matches for a given value. These lookups can be vertical, horizontal, or both.<\/p>\n<p>Fortunately, both functions are available in Microsoft Excel and Google Sheets. Below, you have instructions on how to do a lookup using two criteria: one vertical and one horizontal. In the next section, you have examples with multiple vertical or horizontal criteria. Finally, you have an example combining INDEX, MATCH, and AVERAGE.<\/p>\n<h3>1. Set up criteria<\/h3>\n<p><strong>1. <\/strong>Open Google Sheets to the spreadsheet where you want your lookup results. In this case, I want them in the same sheet as the data, but you can <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-formulas\/importrange\/\" rel=\"noreferrer noopener\" target=\"_blank\">use IMPORTRANGE to search in other files<\/a>.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-sales-table.webp&#8221; alt=&#8221;Google Sheets INDEX MATCH multiple criteria \u2014 monthly sales table with amounts for Anne, Mary, Charlie, and John&#8221; title_text=&#8221;Monthly sales table with amounts for Anne, Mary, Charlie, and John&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2. <\/strong>Type in the criteria or the values you want to search for in separate cells. In this case, the first criterion specifies the row, and the second criterion is the column.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-month-agent-criteria.webp&#8221; alt=&#8221;Google Sheets INDEX MATCH multiple criteria \u2014 Month and Agent criteria cells set to February and Mary next to the table&#8221; title_text=&#8221;Month and Agent criteria cells set to February and Mary next to the table&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p id=\"how-to-use-index-match-with-multiple-criteria-section\">You can easily add drop-down lists in the cells with criteria to make it easier to change them. To learn how to add drop-down lists in Google Sheets, check out this guide on <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/how-to-create-dropdown-lists-in-google-sheets\/\" rel=\"noreferrer noopener\" target=\"_blank\">how to add a drop-down list in Google Sheets<\/a>.<\/p>\n<h3>2. INDEX function<\/h3>\n<p><strong>1. <\/strong>Type the INDEX formula in the cell where you want the lookup result.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-index-function.webp&#8221; alt=&#8221;Google Sheets INDEX MATCH multiple criteria \u2014 =INDEX( typed in the Amount cell with the reference, row, column tooltip&#8221; title_text=&#8221;=INDEX( typed in the Amount cell with the reference, row, column tooltip&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2. <\/strong>For the first argument, select the range of cells containing the table.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-index-range.webp&#8221; alt=&#8221;Google Sheets INDEX MATCH multiple criteria \u2014 table A1:E13 selected as the INDEX reference&#8221; title_text=&#8221;Table A1:E13 selected as the INDEX reference&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>3. MATCH function &#8211; vertical<\/h3>\n<p><strong>1. <\/strong>For the second INDEX argument, type the MATCH function.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-match-function.webp&#8221; alt=&#8221;Google Sheets INDEX MATCH multiple criteria \u2014 MATCH( added as the second INDEX argument with the search_key tooltip&#8221; title_text=&#8221;MATCH( added as the second INDEX argument with the search_key tooltip&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2. <\/strong>For the first argument, select the cell with the vertical lookup value.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-search-key.webp&#8221; alt=&#8221;Google Sheets INDEX MATCH multiple criteria \u2014 month cell G3 selected as the MATCH search key&#8221; title_text=&#8221;Month cell G3 selected as the MATCH search key&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3. <\/strong>For the second argument, select the column you want to search.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-search-column.webp&#8221; alt=&#8221;Google Sheets INDEX MATCH multiple criteria \u2014 month column A1:A13 selected as the MATCH range&#8221; title_text=&#8221;Month column A1:A13 selected as the MATCH range&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>4. <\/strong>The third argument should be \u201c0\u201d, as you want an exact match. Close the parenthesis and add a comma.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-exact-match.webp&#8221; alt=&#8221;Google Sheets INDEX MATCH multiple criteria \u2014 0 entered as the MATCH search type, followed by a comma&#8221; title_text=&#8221;0 entered as the MATCH search type, followed by a comma&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>4. MATCH function &#8211; horizontal<\/h3>\n<p><strong>1. <\/strong>Finally, add another MATCH function. This is the third parameter of the INDEX function, which specifies the column.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-second-match.webp&#8221; alt=&#8221;Google Sheets INDEX MATCH multiple criteria \u2014 second MATCH( added as the INDEX column argument&#8221; title_text=&#8221;Second MATCH( added as the INDEX column argument&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2. <\/strong>Select the cell with the horizontal lookup value as the first argument.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-second-search-key.png&#8221; alt=&#8221;Google Sheets INDEX MATCH multiple criteria \u2014 agent cell H3 selected as the second MATCH search key&#8221; title_text=&#8221;Agent cell H3 selected as the second MATCH search key&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3. <\/strong>Select the row you want to search as the second argument.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-search-row.png&#8221; alt=&#8221;Google Sheets INDEX MATCH multiple criteria \u2014 header row A1:E1 selected as the second MATCH range&#8221; title_text=&#8221;Header row A1:E1 selected as the second MATCH range&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>4. <\/strong>Finally, type \u201c0\u201d for the third argument and add two closing parentheses.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-full-formula.png&#8221; alt=&#8221;Google Sheets INDEX MATCH multiple criteria \u2014 full formula =INDEX(A1:E13,MATCH(G3,A1:A13,0),MATCH(H3,A1:E1,0))&#8221; title_text=&#8221;Full formula =INDEX(A1:E13,MATCH(G3,A1:A13,0),MATCH(H3,A1:E1,0))&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>5. <\/strong>Press \u2018Enter\u2019 to see the result.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-result.png&#8221; alt=&#8221;Google Sheets INDEX MATCH multiple criteria \u2014 Amount cell returns $2,974.34 for Mary in February&#8221; title_text=&#8221;Amount cell returns $2,974.34 for Mary in February&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>6. <\/strong>The function will automatically recalculate as soon as you change the criteria.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-change-criteria.png&#8221; alt=&#8221;Google Sheets INDEX MATCH multiple criteria \u2014 Month changed to June and the result updated to $4,940.30&#8243; title_text=&#8221;Month changed to June and the result updated to $4,940.30&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;index-match-with-multiple-criteria-examp&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>INDEX &amp; MATCH with multiple criteria: examples<\/h2>\n<p>In this section, you have two examples. For the first example, you will find a match using multiple vertical criteria and one horizontal criterion. For the second example, you will combine INDEX and MATCH with AVERAGE to get the average price of a specific product from a particular vendor.<\/p>\n<h3>Lookup with multiple vertical criteria and one horizontal criterion<\/h3>\n<p><strong>1. <\/strong>Open Google Sheets to the spreadsheet with your data.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-vendor-product-table.png&#8221; alt=&#8221;INDEX MATCH multiple criteria in Google Sheets \u2014 vendor and product price table for January to June&#8221; title_text=&#8221;Vendor and product price table for January to June&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2. <\/strong>Type the criteria into separate cells. I have added drop-down lists to those cells to make it easier to select the criteria.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-vendor-product-criteria.png&#8221; alt=&#8221;INDEX MATCH multiple criteria in Google Sheets \u2014 vendor, product, and month drop-downs set to Vendor1, Product3, and April&#8221; title_text=&#8221;Vendor, product, and month drop-downs set to Vendor1, Product3, and April&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3. <\/strong>In the cell where you want the result, type the INDEX function and select the table as the first parameter.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-price-index-range.png&#8221; alt=&#8221;INDEX MATCH multiple criteria in Google Sheets \u2014 =INDEX(A1:H9 typed in the Price cell D12&#8243; title_text=&#8221;=INDEX(A1:H9 typed in the Price cell D12&#8243; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>4. <\/strong>For the second parameter, add the MATCH function. Add \u201c1\u201d as the search key.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-1-search-key.png&#8221; alt=&#8221;INDEX MATCH multiple criteria in Google Sheets \u2014 MATCH(1, added with 1 as the search key&#8221; title_text=&#8221;MATCH(1, added with 1 as the search key&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>5. <\/strong>After the comma, open the parenthesis and add the criterion or condition. Close the parenthesis and add a multiplication sign.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-first-vertical-criterion.png&#8221; alt=&#8221;INDEX MATCH multiple criteria in Google Sheets \u2014 first criterion (A12=A1:A9) followed by a multiplication sign&#8221; title_text=&#8221;First criterion (A12=A1:A9) followed by a multiplication sign&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>6. <\/strong>Open another parenthesis to add the second criterion. Once done, close the parenthesis and add a comma.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-second-vertical-criterion.png&#8221; alt=&#8221;INDEX MATCH multiple criteria in Google Sheets \u2014 second criterion (B12=B1:B9) added after the multiplication sign&#8221; title_text=&#8221;Second criterion (B12=B1:B9) added after the multiplication sign&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>7. <\/strong>Don\u2019t forget to add \u201c0\u201d for an exact match, close the parenthesis, and add another comma.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-vertical-exact-match.png&#8221; alt=&#8221;INDEX MATCH multiple criteria in Google Sheets \u2014 0 added for an exact match, with the INDEX column argument next&#8221; title_text=&#8221;0 added for an exact match, with the INDEX column argument next&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>8. <\/strong>Add another MATCH function. Since you only have one horizontal criterion, simply select the search key (month) and the row where it should be matched.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-horizontal-criterion.png&#8221; alt=&#8221;INDEX MATCH multiple criteria in Google Sheets \u2014 MATCH(C12,A1:H1 added for the month criterion&#8221; title_text=&#8221;MATCH(C12,A1:H1 added for the month criterion&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>9. <\/strong>Finally, type \u201c0\u201d for an exact match and close both sets of parentheses.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-closed-formula.png&#8221; alt=&#8221;INDEX MATCH multiple criteria in Google Sheets \u2014 completed formula with both MATCH functions closed&#8221; title_text=&#8221;Completed formula with both MATCH functions closed&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>10.<\/strong> Press \u2018Enter\u2019 to see the result.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-lookup-result.png&#8221; alt=&#8221;INDEX MATCH multiple criteria in Google Sheets \u2014 Price cell shows $66.12 for Vendor1, Product3 in April&#8221; title_text=&#8221;Price cell shows $66.12 for Vendor1, Product3 in April&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h3>Lookup with multiple criteria &amp; AVERAGE<\/h3>\n<p>In this example, you will learn how to get the average price for a specific product and vendor over the six months of data you have.<\/p>\n<p><strong>1. <\/strong>In the spreadsheet where you want the result, type the criteria into separate cells.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-average-criteria.png&#8221; alt=&#8221;INDEX MATCH with AVERAGE in Google Sheets \u2014 vendor and product criteria above an empty Average Price (Jan.-June) cell&#8221; title_text=&#8221;Vendor and product criteria above an empty Average Price (Jan.-June) cell&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2. <\/strong>In the cell where you want the result, type the AVERAGE function.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-average-function.png&#8221; alt=&#8221;INDEX MATCH with AVERAGE in Google Sheets \u2014 =AVERAGE( typed in the Average Price cell&#8221; title_text=&#8221;=AVERAGE( typed in the Average Price cell&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3. <\/strong>Next, type the INDEX function.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-average-index.png&#8221; alt=&#8221;INDEX MATCH with AVERAGE in Google Sheets \u2014 =AVERAGE(INDEX( with the INDEX reference tooltip&#8221; title_text=&#8221;=AVERAGE(INDEX( with the INDEX reference tooltip&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>4. <\/strong>Select the table as the first parameter for the INDEX function.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-average-select-table.png&#8221; alt=&#8221;INDEX MATCH with AVERAGE in Google Sheets \u2014 table A1:H9 selected as the INDEX reference&#8221; title_text=&#8221;Table A1:H9 selected as the INDEX reference&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>5. <\/strong>Add the MATCH function and type \u201c1\u201d as the search key.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-average-search-key.png&#8221; alt=&#8221;INDEX MATCH with AVERAGE in Google Sheets \u2014 MATCH(1, added inside the INDEX function&#8221; title_text=&#8221;MATCH(1, added inside the INDEX function&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>6. <\/strong>After the comma, add each of your vertical criteria between parentheses, joined by a multiplication sign.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-average-vertical-criteria.png&#8221; alt=&#8221;INDEX MATCH with AVERAGE in Google Sheets \u2014 vendor and product criteria joined by a multiplication sign inside MATCH&#8221; title_text=&#8221;Vendor and product criteria joined by a multiplication sign inside MATCH&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>7. <\/strong>After the comma, add \u201c0\u201d for an exact match and close the three parentheses.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-average-exact-match.png&#8221; alt=&#8221;INDEX MATCH with AVERAGE in Google Sheets \u2014 finished formula with 0 for an exact match and three closing parentheses&#8221; title_text=&#8221;Finished formula with 0 for an exact match and three closing parentheses&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>8. <\/strong>Press \u2018Enter\u2019 to see the result.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/google-sheets-index-match-average-price-result.png&#8221; alt=&#8221;INDEX MATCH with AVERAGE in Google Sheets \u2014 average price of $67.62 for Vendor1, Product3 from January to June&#8221; title_text=&#8221;Average price of $67.62 for Vendor1, Product3 from January to June&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text module_id=&#8221;conclusion&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Conclusion<\/h2>\n<p>INDEX and MATCH offer a more flexible way of performing lookups in Microsoft Excel and Google Sheets. You can quickly look up values in complex tables using multiple vertical and horizontal criteria. You now know how to use INDEX and MATCH to get values based on both vertical and horizontal criteria, including multiple of each. You also know how to combine the INDEX and MATCH functions with others so that you can incorporate the calculation directly into your lookup formula. If you need to add up the values in every row that meets your conditions, rather than return a single match, use <a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-formulas\/sumifs-with-multiple-criteria\/\">SUMIFS with multiple criteria<\/a>.<\/p>\n<p>To learn more about other lookup functions, check out these guides on:<\/p>\n<ul>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-formulas\/vlookup-importrange\/\" rel=\"noreferrer noopener\" target=\"_blank\">How to use VLOOKUP and IMPORTRANGE in Google Sheets<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-formulas\/vlookup-excel-with-two-spreadsheets\/\" rel=\"noreferrer noopener\" target=\"_blank\">How to VLOOKUP in Excel with two spreadsheets?<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-features\/how-to-use-xlookup-in-google-sheets-formulas-and-examples\/\" rel=\"noreferrer noopener\" target=\"_blank\">How to use XLOOKUP in Google Sheets? (+ formulas and examples)<\/a><\/li>\n<li><a href=\"https:\/\/www.sheetgo.com\/blog\/google-sheets-formulas\/combine-query-with-importrange-in-google-sheets\/\" rel=\"noreferrer noopener\" target=\"_blank\">Combine QUERY with IMPORTRANGE in Google Sheets<\/a><\/li>\n<\/ul>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Configure passo a passo pesquisas com INDEX MATCH e v\u00e1rios crit\u00e9rios no Google Sheets: crit\u00e9rios verticais, horizontais e mistos, al\u00e9m de um exemplo com AVERAGE.<\/p>","protected":false},"author":2,"featured_media":262979,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[],"class_list":["post-262946","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/262946","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=262946"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/262946\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/262979"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=262946"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=262946"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=262946"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}