If you can swap those columns, then you could do a VLOOKUP

=VLOOKUP(MAX(A:A),A:B,2,FALSE)

would get it.



"Pablo" wrote:

I know this is really easy in Access, but unfortunately I have to work on
Excel...

I need to do a query that will search for the maximum value and give me the
type. Here's the example:

A B
1 Categories Results
2 Type 1 10
4 Type 2 30
5 Type 3 20


In this case, the maximum value for this array is 30. I want my query to
find the 30 and give me "Type 2" as the result.

I hope that this can be done with built-in formulas, rather than adding a
v-basic macro... Thank you!

Pablo