Index Match with multiple criteria - Return top sellers for certain week from year data

Hello,

I'm currently using the following formulas to return the top 10 products with highest sales for the attached file:

=INDEX(A:A,MATCH(LARGE(C:C,1),C:C,0))

=INDEX(A:A,MATCH(LARGE(C:C,2),C:C,0))

=INDEX(A:A,MATCH(LARGE(C:C,3),C:C,0))

...etc

This works great and returns the top 10 for the entire year, but I would I would like to be able to also just get the top 10 for a certain week (e.g. week 52). Is there a way to do this using formulas as I would like to avoid using Pivot Tables if at all possible?

I have tried =INDEX(A:A,MATCH(LARGE(C:C,3)&"52",C:C&B:B,0)) with no success, and I'm not really familiar enough with INDEX MATCH to understand more complex versions beyond the basics so any help would be hugely appreciated!

Thank you!

Amazing! Thank you so much Glenn, it works perfectly! :D

Hi albanhac,

Another option could be: {array}
=SUMIF($C$2:$C$2751,LARGE(IF($B$2:$B$2751=52,$C$2:$C$2751),1),$A$2:$A$2751)

To be entered with CSE

Blessing

Hi Khalidngo, thank you for you reply. Unfortunately your formula didn't work for me

Originally Posted by albanhac

Hi Khalidngo, thank you for you reply. Unfortunately your formula didn't work for me

Hmm dear, are you sure?