Displaying contents of adjacent cells.
 

I have a list of scores on a rewards scheme sheet. adjacent to these scores
are the names of the record holders. IF scores are in B1:B16 the names are in
A1:A16. I've used the max feature to find the max score and display in cell
G12. I would like the name of the record holder to appear in cell G11
automatically. how do i do this? Any help would be greatly appreciated

This will work, but it will get the name of the first matching Max sco

=INDEX(A1:A16,MATCH(G12,B1:B16))

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"MikeyB" wrote in message
...
I have a list of scores on a rewards scheme sheet. adjacent to these scores
are the names of the record holders. IF scores are in B1:B16 the names are
in
A1:A16. I've used the max feature to find the max score and display in
cell
G12. I would like the name of the record holder to appear in cell G11
automatically. how do i do this? Any help would be greatly appreciated

Try this:-

=INDEX(A1:A16,MATCH(G12,B1:B16,0))

One problem, if you have more than one person with the same score, it
will only display the first one in the list, if this won't happen, it
shouldn't be a problem


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=390513

Can't get this to work. Its returning names but not the correct ones.

to clarify....

names are in A5:A15, scores in B5:B16, max score displayed through
"=MAX(B5:B16)" in B28. I want the name that matches the score displayed in
B28 to appear in B27.

Similarly i'm gonna be using the same thing for the score displayed in
B30(appearing in A30) for ranges A/B17:A/B26 and the score in B31 for ranges
C/D5:C/D16. presume it would be easy to change cell numbers.


"Damon Longworth" wrote:

This will work, but it will get the name of the first matching Max sco

=INDEX(A1:A16,MATCH(G12,B1:B16))

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"MikeyB" wrote in message
...
I have a list of scores on a rewards scheme sheet. adjacent to these scores
are the names of the record holders. IF scores are in B1:B16 the names are
in
A1:A16. I've used the max feature to find the max score and display in
cell
G12. I would like the name of the record holder to appear in cell G11
automatically. how do i do this? Any help would be greatly appreciated

Try:

=INDEX(A5:A16,MATCH(B28,B5:B16))

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"MikeyB" wrote in message
...
Can't get this to work. Its returning names but not the correct ones.

to clarify....

names are in A5:A15, scores in B5:B16, max score displayed through
"=MAX(B5:B16)" in B28. I want the name that matches the score displayed in
B28 to appear in B27.

Similarly i'm gonna be using the same thing for the score displayed in
B30(appearing in A30) for ranges A/B17:A/B26 and the score in B31 for
ranges
C/D5:C/D16. presume it would be easy to change cell numbers.


"Damon Longworth" wrote:

This will work, but it will get the name of the first matching Max sco

=INDEX(A1:A16,MATCH(G12,B1:B16))

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"MikeyB" wrote in message
...
I have a list of scores on a rewards scheme sheet. adjacent to these
scores
are the names of the record holders. IF scores are in B1:B16 the names
are
in
A1:A16. I've used the max feature to find the max score and display in
cell
G12. I would like the name of the record holder to appear in cell G11
automatically. how do i do this? Any help would be greatly appreciated

tried this one, but its still not returning the correct name. seems to
generate the last on the list, which isnt the highest value.

"Damon Longworth" wrote:

Try:

=INDEX(A5:A16,MATCH(B28,B5:B16))

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"MikeyB" wrote in message
...
Can't get this to work. Its returning names but not the correct ones.

to clarify....

names are in A5:A15, scores in B5:B16, max score displayed through
"=MAX(B5:B16)" in B28. I want the name that matches the score displayed in
B28 to appear in B27.

Similarly i'm gonna be using the same thing for the score displayed in
B30(appearing in A30) for ranges A/B17:A/B26 and the score in B31 for
ranges
C/D5:C/D16. presume it would be easy to change cell numbers.


"Damon Longworth" wrote:

This will work, but it will get the name of the first matching Max sco

=INDEX(A1:A16,MATCH(G12,B1:B16))

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"MikeyB" wrote in message
...
I have a list of scores on a rewards scheme sheet. adjacent to these
scores
are the names of the record holders. IF scores are in B1:B16 the names
are
in
A1:A16. I've used the max feature to find the max score and display in
cell
G12. I would like the name of the record holder to appear in cell G11
automatically. how do i do this? Any help would be greatly appreciated

Is there a match? Try adding the False argument:

=INDEX(A5:A16,MATCH(B28,B5:B16,0))




--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"MikeyB" wrote in message
...
tried this one, but its still not returning the correct name. seems to
generate the last on the list, which isnt the highest value.

"Damon Longworth" wrote:

Try:

=INDEX(A5:A16,MATCH(B28,B5:B16))

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"MikeyB" wrote in message
...
Can't get this to work. Its returning names but not the correct ones.

to clarify....

names are in A5:A15, scores in B5:B16, max score displayed through
"=MAX(B5:B16)" in B28. I want the name that matches the score displayed
in
B28 to appear in B27.

Similarly i'm gonna be using the same thing for the score displayed in
B30(appearing in A30) for ranges A/B17:A/B26 and the score in B31 for
ranges
C/D5:C/D16. presume it would be easy to change cell numbers.


"Damon Longworth" wrote:

This will work, but it will get the name of the first matching Max
sco

=INDEX(A1:A16,MATCH(G12,B1:B16))

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"MikeyB" wrote in message
...
I have a list of scores on a rewards scheme sheet. adjacent to these
scores
are the names of the record holders. IF scores are in B1:B16 the
names
are
in
A1:A16. I've used the max feature to find the max score and display
in
cell
G12. I would like the name of the record holder to appear in cell
G11
automatically. how do i do this? Any help would be greatly
appreciated

Thanks mate, there was no match. but it seems the 0 helped, why is this?

"Damon Longworth" wrote:

Is there a match? Try adding the False argument:

=INDEX(A5:A16,MATCH(B28,B5:B16,0))




--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"MikeyB" wrote in message
...
tried this one, but its still not returning the correct name. seems to
generate the last on the list, which isnt the highest value.

"Damon Longworth" wrote:

Try:

=INDEX(A5:A16,MATCH(B28,B5:B16))

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"MikeyB" wrote in message
...
Can't get this to work. Its returning names but not the correct ones.

to clarify....

names are in A5:A15, scores in B5:B16, max score displayed through
"=MAX(B5:B16)" in B28. I want the name that matches the score displayed
in
B28 to appear in B27.

Similarly i'm gonna be using the same thing for the score displayed in
B30(appearing in A30) for ranges A/B17:A/B26 and the score in B31 for
ranges
C/D5:C/D16. presume it would be easy to change cell numbers.


"Damon Longworth" wrote:

This will work, but it will get the name of the first matching Max
sco

=INDEX(A1:A16,MATCH(G12,B1:B16))

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"MikeyB" wrote in message
...
I have a list of scores on a rewards scheme sheet. adjacent to these
scores
are the names of the record holders. IF scores are in B1:B16 the
names
are
in
A1:A16. I've used the max feature to find the max score and display
in
cell
G12. I would like the name of the record holder to appear in cell
G11
automatically. how do i do this? Any help would be greatly
appreciated