Thread: VLOOKUP and MAX/MIN functions

How about this?

=INDEX(A:A,MATCH(MAX(B:B),B:B,0))

that will bring you first max result.

That would be nice since it's very usefull and common:

INDEX(array,row_num,column_num)

So, in some array you enter row number and column number and get result from that cell.

INDEX(A1:B2, 2, 2) will return whatever is in B2 cell.

Now, let's go step further:

=INDEX(A:A,something,) will return actually row number calculated by something (no need of column number since it's one dimensional array A:A)

something is your issue.. in this case MAX

=MATCH(MAX(B:B),B:B,0)

MATCH(lookup_value, lookup_array, [match_type])

And lookup value is MAX in this case... Actually, this formula returns number in wich cell is maximum value in B column.

Of course, that's the value we use above in INDEX function.

so, let's summarise:

=INDEX(A:A,MATCH(MAX(B:B),B:B,0))

Formula find MAX value in B column.
Then MATCH returns where is that value in B column.
Then INDEX returns what's in same row of that value...

maybe would be nice to test formula evaluation at this time because I'm not good explainer