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

[jshonuff]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Column1
[/TD]
[TD]Column2
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]150%
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]100%
[/TD]
[/TR]
</tbody>[/TABLE]



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))