You want to return all three scores, probably the easiest, least confussing
way to do it is with three vlookup formulas.
=VLOOKUP($A$12,$A$1:$D$8,2,FALSE)
will find the first score, then in the cell to the right, enter:
=VLOOKUP($A$12,$A$1:$D$8,3,FALSE)
the only difference is the column number you're getting a return from, so
copy and paste works great.
Of course, for the third score you change the 3 to a 4.
So this, in four cells in a row:
Chris =VLOOKUP($A$12,$A$1:$D$8,2,FALSE) =VLOOKUP($A$12,$A$1:$D$8,3,FALSE) =VLOOKUP($A$12,$A$1:$D$8,4,FALSE)
Gives this result:
Chris 80 95 85
Type in a new name where Chris is and you get new scores.
Have fun!

"Chris Adolph" wrote:

Ok, I cannot seem to get that to work. I revised the formula to fit the data
I have (changed the_name to the name I needed, ect). Below I have copied a
simple version of what I am trying to accomplish:

A B C D
1 Name Score 1 Score 2 Score 3
2 Chris 80 95 85
3 Andy 75 90 80
4 David 70 85 75
5 Shannon 65 80 70
6 Ryan 60 75 65
7 Bob 55 70 60
8 Ed 50 65 55

I want to write a formula in another cell that looks for lets say Chris in
column A. If an occurence of that name is found, then I would like for it to
return Chris, and the corresponding cells to the right of the name. Does
this make any sense?

Thanks anyone,

--
Chris Adolph



"Bob Phillips" wrote:

=SUM(INDEX(B1:H100,MATCH(the_name,A1:A100,0),0))


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Chris Adolph" wrote in message
...
I have 7 columns (1st with names, the next 6 with % scores). I am wanting
a
formula to find a specific name in the first column (reading down) and
return
the results of the 6 columns to the right of the name. Any ideas on how
to
accomplish this?

Thanks,
--
Chris Adolph