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

I am having a column say A having some numeric values from A1 to A7. An another column say B having some values given to each one of that numeric value in column A. Now I put a formula of max on column A and whatever the result is(max cell value), I want to retrieve the respective value of column B in any other cell say C1.


For example:

Say A1 to A7, A3 contains maximum value 72 of all the numeric from A1 to A7.......I put a max function from A1 to A7 and it returns A3 value that is 72. Now say respective column B contains the value 300 in B3. Now I want to return that 300 value in some another cell.

just in sequence that I want

1. Max of column A.
3. Take the respective value of column B say B3 and return that value of B3 in another Cell say C3.

Plz help out friends.