If or Lookup condition

Why are you bothering with a separate analysis range when you are already using a Pivot Table. Seems like the proverbial sledgehammer/nut scenario.

Either change the Value Field setting in the PT from Sum to Max, or if you want both add a second Value Field for Sales and set it to Max

- Right click on Pivot table
- Pivot table options -- Totals & Filters -- Uncheck 'Show grand totals for columns'

Then in R7 use
=IFERROR(INDEX(A:A,MATCH(MAX(INDEX(B:M,,MATCH(Q7,$B$5:$M$5,0))),INDEX(B:M,,MATCH(Q7,$B$5:$M$5,0)),0)),0)

Copy down

Thanks a lot for the equation,

but when I am trying to use the Year in the Column Labels in Pivot Table, the equation gives me 0 for Jan.

Can you please solve it to me.

Example:

Pivot Table:
in column table:
Year
Month