Forum Discussion
Solved
INDEX and MATCH to find max from specific year
Good morning, I'm having trouble with extracting the region that records the most sales for the "Furniture", "Office Supplies" and "Technology" only for the year 2015 using INDEX() and MATCH(). ...
=INDEX(A4:A22,MATCH(LARGE(IF(B4:B22=D24,C4:C22),1),C4:C22,0))
Is this what you are looking for? I have to enter formula with ctrl+shift+enter. The year can be entered in cell D24 in my example.
.png){kind=link}
=INDEX(A4:A22,MATCH(LARGE(IF(B4:B22=D24,C4:C22),1),C4:C22,0))
Is this what you are looking for? I have to enter formula with ctrl+shift+enter. The year can be entered in cell D24 in my example.