Forum Discussion
Solved
Assistance needed with Index/Match or another alternative
Could someone please assist with the following: Sheet1 contains a number of different scales (Scale1, Scale2, Scale3...) that are numeric or alphanumeric. The main scale has values 0 to 100. A...
Spicierboar , as variant, for such model
=AGGREGATE(14,6,1/(INDEX(A3:G4,MATCH(B6,A3:A4,0),2):INDEX(A3:G4,MATCH(B6,A3:A4,0),7)=B7)*$B$2:$G$2,1)
Spicierboar , as variant, for such model
=AGGREGATE(14,6,1/(INDEX(A3:G4,MATCH(B6,A3:A4,0),2):INDEX(A3:G4,MATCH(B6,A3:A4,0),7)=B7)*$B$2:$G$2,1)
SergeiBaklan This works. Thank you.
Spicierboar , you are welcome