Hi Steve,

Try this:

=INDEX(A:A,MATCH(MAX(B:B),B:B,0))

Regards,
KL


"Steve Jackson" wrote in message
. ..
Hi,

I have 2 columns of data. Column A has a list of names (text) - i.e Jack,
John, Pete, Greg. Column B has points (integer numbers) - i.e 1, 7, 1, 5.

I want to use a function that works out what the highest points in column
B
is and then returns the corresponding name in column A.

Example:
Column A Column B
Jack 1
John 7
Pete 1
Greg 5

The answer to the function should return John because it is 1 column to
the
left of the highest points from column A.

Can anyone help?

Steve