Introduction. For decades, INDEX and MATCH have been the go-to solution for handling complex lookup problems. Unlike VLOOKUP, INDEX and MATCH are based on numeric positions: the MATCH function locates the position of a value, and the INDEX function retrieves a value at that position. This approach makes INDEX and MATCH highly versatile, at the cost of more configuration. To perform a multi-criteria lookup and transpose results into a table, you can use an array formula based on INDEX and MATCH. In the example shown, the formula in G5 is: I am a newbie and I understand the general index match lookups. However I am struggling with a more complicated set of information that needs an index match but with applicability criteria. Example as follows (formula to be built in cell L4): 1. Lookup material description Bracket in column B (there are 3 bracket options) 2. 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. What you want is another index formula within the match formula. So an index-match-index formula. =INDEX (Time1:Time9, MATCH (1, INDEX ( ( [lookup 1]1 = [part 1]1: [part 1]9)* ( [lookup 2]1 = [part 2]1: [part 2]9)* ( [lookup 3]1 = [part 3]1: [part 3]9)),0,1), 0)) Wilbsguy . 12/12/18. I know it has been a while but if you still need something, I The most popular way to do a two-way lookup in Excel is by using INDEX MATCH MATCH. This is a variation of the classic INDEX MATCH formula to which you add one more MATCH function in order to get both the row and column numbers: INDEX ( data_array, MATCH ( vlookup_value, lookup_column_range, 0), MATCH ( hlookup value, lookup_row_range, 0)) .

formula index match multiple criteria