Excel formula to retrieve value of a respective cell wid a max function on anothr cell

I can explain it fully, but you will need to change the post title so something more descriptive of the problem.
The one you had before was better than the current title.

Moderators give us bad points if we go against the rules.