dabug80
asked on
Excel: Max lookup value (based on date)
Hello,
I would like to return the max value of a product within a given date range. Would this be done with a max/index match formula? I'm not sure how to approach it.
Then, once this max value is established, return the name of the person who achieved this result.
See the attached spreadsheet.
Thanks for your help
ee-findmax.xlsx
I would like to return the max value of a product within a given date range. Would this be done with a max/index match formula? I'm not sure how to approach it.
Then, once this max value is established, return the name of the person who achieved this result.
See the attached spreadsheet.
Thanks for your help
ee-findmax.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent. Thanks
You're welcome. Glad to help.
In C26
=MAX(INDEX(C4:H21,MATCH(B2
And
In D26
=INDEX(C2:H2,MATCH(C26,IND
This is for Product1. You have to make the similar formulas for other Products.
Is this what you are trying to achieve?