Hello all. I want to ask help as i'm lost in the woods. i want to get the row header (which is column players) based on the criteria points and quarters. column G:I are the actual, while column K:M is manually encoded just to show my desired output. i read and tried this reverse lookup to get column headers, (Q1,Q2,Q3,Q4). is there a way to get the players (P1-P9) based on criteria points and quarters?
heres the code for the getting column headers based on players & pts.
=INDEX(B2:E2,,MATCH(D15,INDEX(B3:E11,MATCH(C15,A3:A11,0),),0))
Attachment 700142
Bookmarks