Max value lookup

Hi Team,

I am looking for the formula where if lookup value matches the lookuparray then formula should pick the max value for the match and return corresponding value.

for better understanding please refer the attached excel file.

I request you to kindly look into this and advise.

Thank you.

Regards,

Rehaman

Hi Team,

Unable to Edit my post so using reply option.

Here i have cross posted

Thank you.

Regards,

Rehaman.

Hi Team,

Please close the post as I got the solution.

https://www.mrexcel.com/board/…ax-value-formula.1197241/

Thank you.

Regards,

Rehaman.