Sameer.k21
Member
I have huge list of items from which I am trying to create a dashboard. I tried to use Index and Match - need help with multiple criteria and multiple range while using Index and Match formula. Any suggestions would be appreciated.
attached are the sample photos. Not sure how to upload the sample file here.
formula used is - =INDEX(INDEX(Backend!$G$2:$T$57,,MATCH(Dashboard!E$4,Backend!$G$1:$T$1,0)),MATCH(Dashboard!$B5,INDEX(Backend!$E$2:$E$57,,MATCH($C$2,Backend!$F$9:$F$57,0)),0))
attached are the sample photos. Not sure how to upload the sample file here.
formula used is - =INDEX(INDEX(Backend!$G$2:$T$57,,MATCH(Dashboard!E$4,Backend!$G$1:$T$1,0)),MATCH(Dashboard!$B5,INDEX(Backend!$E$2:$E$57,,MATCH($C$2,Backend!$F$9:$F$57,0)),0))