LOOKUP mechanics

Originally Posted by DonkeyOte

http://www.excelforum.com/excel-misc...-new-post.html

Perhaps:

Please Login or Register  to view this content.

Note:
if you have 1+ instances of MAX value in I then the above would return the last value in B associated with the MAX value... if you wished to return the first value in B associated with the MAX you see the prior post by Jeff.

In the code above what is being represented by the 2,1/ ?

Welcome to the Board.

As you can see I have moved your post from the original thread into your own - we prefer people ask their own questions in their own threads (referring to original thread in their own thread as needed).

To answer your question... have a look at these other threads in which I tried to explain the mechanics of using this approach:

http://www.excelforum.com/excel-work...te-values.html
http://www.excelforum.com/excel-2007...-function.html

Hopefully from reading the above your question will be answered.