INDEX MATCH MAX Query

Have attached a very condensed version of my document.

In cell D3, I would like it to show me for example the highest value SKU for Tobacco when Tobacco has been selected in C2.
And if C2 is left at "All Categories" it will show the highest value SKU across all categories.
So far I have IF(C2="ALL CATEGORIES",INDEX($C$8:$C$928,MATCH(MAX($E$8:$E$928),$E$8:$E$928,0)) which covers the all categories part.

Sorry if I am over complicating this.

Thanks