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

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

See my post in:

http://tinyurl.com/562xz

Steve Jackson wrote:
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



--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.