VLOOKUP return using =MAX 2

[Chris559]

I want the VLOOKUP to return the name in Column A of the highest value in column B. I thought that my lookup at the bottom would work - but doesn't. Any suggestions?

A&B £450.00
Tesco £322.00
Scouts £160.00
Teashop £25.00
Take Away £60.00
Flower shop £75.00


VLOOKUP((=max(C7:C12),B7:C12,1,true)

 

[SkipVought]

hi,
[tt]
=INDEX(B7:B12,MATCH(MAX(C7:C12),C7:C12,0),1)
[/tt]


Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[xlhelp]

=LOOKUP(MAX(C7:C12),C7:C12,B7:B12)


Avoid Hangovers. Stay drunk.

 

[Chris559]

thanks skip - works a treat

thanks to xlhelp, but yours returns Flower shop which is the lowest not the highest (A&B)

 

[SkipVought]

LOOKUP, it seems, works as expected when the amount column is sorted ascending.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]