Returning the contents of one cell based on contents of another

[mike4777]

I've got my database setup to return a score based on a series of questions. Each set of questions falls under a subject and I am trying to display both results and the category it came from. BL2:BL29 contains the final scores. a2:a29 are the list of subjects with a2 corresponding with bl2, etc. I have a formula to display the top 5 highest results from BL column. I need the names of those high scores in column a next to the score. I think column function is involved somehow but any help would be appreciated.

 

[Aladin Akyurek]

well, what I'm confused about is what bo2 refers to. bo1 is empty. and I plugged in the formulas and they aren't doing anything? Is it possible to upload the workbook anymore or did they remove that feature?

BO1 is not empty. This cell houses the number 5, indicating that we want a Top N list of categories where N = 5.

BO2 contains a formula that adjusts the size of the list in case the Nth (5th) value has ties. The example scores
that I used display such ties. The formula of this cell is:

=COUNTIF(BL2:BL29,">="&LARGE(BL2:BL29,BO1))