Excel INDEX MATCH with multiple criteria - formula examples - Ablebits
https://www.ablebits.com/office-addins-blog/excel-index-match-multiple-criteria-formula-examples/
WEBMar 14, 2023 · {=INDEX ( return_range, MATCH (1, ( criteria1 = range1) * ( criteria2 = range2) * (…), 0))} Where: Return_range is the range from which to return a value. Criteria1, criteria2, … are the conditions to be met. Range1, range2, … are the ranges on which the corresponding criteria should be tested. Important note!
DA: 11 PA: 18 MOZ Rank: 70