Advanced Excel - INDEX and MATCH with multiple criteria with incremental match return

To all the excel experts out there, I need help on an advanced formula. I am trying to use an INDEX MATCH formula that is configured with MATCH set to look through a one-column range and provide a match based on given criteria. The sample criteria looks at Category A and Category B, then assigns the group number through the predefined index table.

This formula uses boolean logic to create an array of ones and zeros to represent rows matching both criteria, then uses MATCH to match the first 1 found. This is a LIMITATION as I need the matches to return subsequent Groups. I will share some illustration file with shortlisted candidates. Please help!

I was able to get the first index match, through the tutorial from exceljet.

But, its only returning the first criteria row value that matches. Not results of the subsequent matches.
About the recuiter
Member since Nov 11, 2022
Preeti Bhardwaj
from Hubei, China

---

---

Offer to work on this project closes in 187 days!
Are you interested in this Opportunity?

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions