Hi all,

My problem is this:

I have two columns:
Column B is stock symbols
Column F is percentage growth

B F
- -
AAAE 1.0%
BAC 2.67%
BKC 3.8%
WEN -5.7%

I would like to use a max function to first find the maximum value in column F. I then want to return the corresponding stock ticker from column B.

What I have so far (which is clearly not working) is this: =VLOOKUP(MAX(F1:F4),1,B1:F4)

Any ideas? Thank you for your time. :-)