Formualu to extract period vbased on values

I would like a formula to extract the month & year based on various values ranging from the highest value to the 5th highest value-see attached sample


Your assistance in this regard is most appreciated

Hi

In C9,

=INDEX($B$1:$M$4,MAX(IF($B$2:$M$5=B9,ROW($B$2:$B$5 )-ROW($B$2)+1,)),MAX(IF($B$2:$M$5=B9,COLUMN($B$2:$M$ 2)-COLUMN($B$2)+1,)))

Array entered.

Thanks for the help, much appreciated

It would be appreciated if you can explain how this formula works

Hi Howardc,

Please post the link while posting the same question on differen forums.

Cross Post

Will do so in future