I'm trying to lookup the max sales for a month by employee. The Pivot Table shows the layout. I know i could just use a max function to return each number, but I want a formula that will lookup an employee's name and return its max value. Additionally, I want to lookup the calculated max value and return its corresponding product ID. Any ideas for me?