You have used an array formula without pressing Ctrl+Shift+Enter. When you use an array in INDEX, MATCH, or a combination of those two functions, it is necessary to press Ctrl+Shift+Enter on the keyboard. Excel will automatically enclose the formula within curly braces {}. If you try to enter the brackets yourself, Excel will display the I'm trying to pull prices based on whether the code matches, and if the date is within a certain range. I want to pull column H based on these conditions: . Columns A and F match; Column G is between or equal to columns B and C; I figured an array formula with INDEX/MATCH would be the best method, but have not been successful so far.. I've been attempting a formula using logic similar to this: 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 Index works ok: Selection.Value = WorksheetFunction.Index (Range ("F2:F34"), 19) 'returns the 19th value in the Range. So far so good. The Match function works well like this with only one column (Date) being searched. Selection.Value = WorksheetFunction.Match (Range ("K2"), Range ("A2:A34"), 0) 'returns the date searched for from a column of 18nV.

formula index match multiple criteria