If this is the MAX In one column then put this from another column

[jshonuff]

Column1	Column2
2	150%
3	100%

<tbody>
</tbody>

How do I write, get the MAX value from column2 and Display the name for column1 to another cell in a formula?

So the answer should be (2)

This is only based on the max value and nothing else.

 

[njimack]

=index(a2:a3,match(max(b2:b3),b2:b3,0))