Thanks for the fantastic post! I have one question. Sometimes when I am using a two criteria formula with index and match just as you described. I want to return a "0" or blank if the result is #N/A. Thanks for taking the time to write this fantastic explanation for using INDEX and MATCH for multiple criteria. I've actually been using 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. Convert index match with multiple criteria into VBA. I would like to translate the index match formula below into a macro. The excel formula works perfectly but when i code it using a for loop but not sure why the values are populated as #NA from C2 to last row.. Excel Formula : =INDEX (' [640910 690606641710_Jan to Jul''22_working.xlsx]Sheet1 To lookup in value in a table using both rows and columns, you can build a formula that does a two-way lookup with INDEX and MATCH. In the example shown, the formula in J8 is: =INDEX (C6:G10,MATCH (J6,B6:B10,1),MATCH (J7,C5:G5,1)) Note: this formula is set to "approximate match", so row values and column values must be sorted. The MATCH function searches for a specified item in a range of cells, and then returns the relative position of that item in the range. For example, if the range A1:A3 contains the values 5, 25, and 38, then the formula =MATCH (25,A1:A3,0) returns the number 2, because 25 is the second item in the range. Tip: Use MATCH instead of one of the Vay Tiền Nhanh Chỉ Cần Cmnd Nợ Xấu.

formula index match multiple criteria