Hi all!

Having trouble with this one. I have the 2 separate pieces working, but I can't seem to figure out how to put them together.

Okay, so basically I am trying to format a record book that uses data from another sheet. Here is a screenshot of what it will look like:

Screen Shot 2019-07-02 at 11.44.26 AM.png

So, I have figured out how to get the number, which includes multiple criteria. The formula for that looks like this:
=MAXIFS('2007'!$I2:$I$269,'2007'!AB$2:$AB$269,'2007'!$F$282,'2007'!AC$2:$AC$269,'2007'!$F$284)
Next, I want to get the corresponding name, and week #, which are all on the same row as the previous number. I have not been able to figure out how to do that. I have this: 
=INDEX('2009'!$F$2:$F$281,MATCH(MAX('2009'!I$2:I$281),'2009'!I$2:I$281,0))
Which sort of works, but it only gets the max, and does not include the criteria ($AB and $AC) that I need filtered. I'm unsure of how to add those criteria.

Lastly, and this isn't the hugest deal in the world, but it would be nice, is I know that this will only return the first value if there are duplicates. Is there a way to print each value of duplicates?

For example, something like this:
Screen Shot 2019-07-02 at 11.52.09 AM.png

Thanks so much!