brianfosterblack
Active Member
- Joined
- Nov 1, 2011
- Messages
- 251
Can someone please help me with this
I am working in a worksheet (named Report) and have to find the person ranked first in a certain category on another worksheet
The other worksheet is named "scores"
I have used a match formula to find the applicable category on the scores sheet between a range AL2:BL2
From there I got the column number (In this case column 39) and then using the address formula I got the column address "Scores!AM2" - This result in the formula reflects in Report!I19
That is where I am stuck
What I need help with is the rest of the formula to find the number 1 in the column matched (it will be between row 3 and 203 of that column) and then pick up the name in the same row in Range Scores!C3 to Score!C203
Any assistance would be most welcome
Thank you.
I am working in a worksheet (named Report) and have to find the person ranked first in a certain category on another worksheet
The other worksheet is named "scores"
I have used a match formula to find the applicable category on the scores sheet between a range AL2:BL2
From there I got the column number (In this case column 39) and then using the address formula I got the column address "Scores!AM2" - This result in the formula reflects in Report!I19
That is where I am stuck
What I need help with is the rest of the formula to find the number 1 in the column matched (it will be between row 3 and 203 of that column) and then pick up the name in the same row in Range Scores!C3 to Score!C203
Any assistance would be most welcome
Thank you.