Note this is an array formula that must be entered with control + shift + enter in Excel 2019 and earlier. Note: The purpose of this example is to explain how to get the nth match in Excel 2019 and older with an INDEX and MATCH formula. In the current version of Excel, the FILTER function is a much better way to get multiple matching records. In the video below I show you 2 different methods that return multiple matches: Method 1 uses INDEX & AGGREGATE functions. It's a bit more complex to setup, but I explain all the steps in detail in the video. It's an array formula but it doesn't require CSE (control + shift + enter). Method 2 uses the TEXTJOIN function. The VLookup Multiple Criteria (with INDEX MATCH) Formula Template/Structure. The Example Before VLookup Multiple Criteria (with INDEX MATCH) Step 1: Set Up the Multiple Conditions. Step 1 Example. Step 2: Use the MATCH Function to Find the Row Where the Multiple Conditions are Met. Step 2 Example. BILLYBOB1972. I'm ok with index match formulas but I'm stuck with working out how to use a match with multiple criteria and finding a value based on a date range. In the example below I need to match the reference but also find the price based on the date. The value in cells c2 & c3 should return 5.5 and cell c4 should return 5.75. You can use the following syntax with INDEX and MATCH to look up a value in one column where specific criteria are met in 3 other columns: =INDEX (D2:D10,MATCH (1, (G1=A2:A10)* (G2=B2:B10)* (G3=C2:C10),0)) This particular formula looks up the value in the range D2:D10 where the following three criteria are met: The following example shows how How to Use INDEX and MATCH Together in Excel 365. To use INDEX and MATCH together to look up multiple values in Excel, you need to use an array formula. Working with the earlier sample data, this is the formula in Excel 365: =INDEX(A1:A5, MATCH({"apple","banana","cherry"}, A1:A5, 0)) The above example breaks down as this: 1. Combine INDEX and MATCH Functions in Array Formula with Multiple Criteria. 2. Combine INDEX and MATCH Functions in Non-Array Formula with Multiple Criteria. 3. Combine COUNTIFS, INDEX, and MATCH Functions for Multiple Criteria. 4. Utilize COUNTIFS Function with Different Logics for Multiple Criteria. 4.1 COUNTIFS Function with AND Logic. In Microsoft Excel, the combination of INDEX, MATCH & MAX functions is one of the most comprehensive formulas which will let you extract maximum or largest values under multiple criteria. In this article, you'll get to know how we can use INDEX, MATCH & MAX functions together to find out the largest values from a table or an array. The MATCH function is available in any version of Excel 365 through Excel 2007. That's how to use the XMATCH function in Excel. I thank you for reading and hope to see you on our blog next week! Practice workbook for download. Excel XMATCH formula examples (.xlsx file) You may also be interested in. INDEX MATCH with multiple criteria In general, =INDEX(MATCH, MATCH) is not an array formula, but a normal one. However, your case is different - you are not matching rows and columns, but two columns, thus it should be. Array formulas are implented with Ctrl+Shift+Enter. If you have your data like this: Then this is the Array Formula in G1: =INDEX(A1:A6,MATCH(1,(E1=B1:B6)*(F1=C1 YJBG.