I have a table that contains multiple ID & products. In cell F2 & F3, I would like to return the product based on the max value (largest sales in column C).
Is there any Excel function I can use to get this?
1 Answers
You can do it with this formula:
=INDEX(B3:D9,MATCH(MAX((B3:B9=F3)*D3:D9),D3:D9,0),2)
Note: This is an array formula; CTRL + SHIFT = ENTER keys must be pressed together
Related