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.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

#4

Please Login or Register  to view this content.

It's a forumrule, so it counts for every-one (also for you).

Please Login or Register  to view this content.

You don't realize we member who offering or free time, so please be patient.

Hey oeldere bro, I also dont know your netherland language .....and bro I joined today. If you know the answer then answer, otherwise skip. Thanks for your time and advice. I dont know the rules. I just have a doubt and with time I will also get to know that.

thats a tad rude,when you join the forum you agree to the rules,just because you couldn't be bothered to read them its hardly oeldere's fault is it?
http://www.excelforum.com/forum-rule...rum-rules.html
its right at the top you cant miss it

Please Login or Register  to view this content.

You don't realize we are member who offering or free time, so please be patient.