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)
Hi
Sounds like you could use MAXIFS to bring back the max value from Main Scale that corresponds to the selected Scale
e.g. = MAXIFS( MainScaleColumn, ScaleColumn, SelectedScale)
Sounds like you could use MAXIFS to bring back the max value from Main Scale that corresponds to the selected Scale
e.g. = MAXIFS( MainScaleColumn, ScaleColumn, SelectedScale)