Forum Discussion
zaidmorad
Jan 03, 2021Copper Contributor
Finding a Unique Rank based on Drop Down Lists
Hi everyone, I'm in a bit of a pickle and was hoping to get some help. I am working on a project where I am trying to find the unique rank of something based on its score depending on a chang...
HansVogelaar
Jan 03, 2021MVP
In B10:
=INDEX($A$3:$A$6,MATCH($A10,INDEX($J$3:$M$6,,MATCH($A$9,$J$2:$M$2,0)),0))
In B16:
=INDEX($A$3:$A$6,MATCH($A10,INDEX($J$3:$M$6,,MATCH($A$15,$J$2:$M$2,0)),0))
See the attached version.
zaidmorad
Jan 06, 2021Copper Contributor