However, that INDEX MATCH Function combination was for a lookup based on a single criterion. Although it was for a single criteria lookup, we covered the INDEX MATCH Function combination in our piece on the INDEX Function. For a multiple criterion lookup, we would be going through how to mix the INDEX and MATCH Functions. Visit our website for more details on index match various criteria. www.modelsbytalias.com/index-and-match-with-multiple-criteria/
