Hi Chris

Bob assumed you wanted to add the 6 values found in the row adjacent to
where the name was found and his formula achieves this.

Try the following. I assumed the name you were typing in was in cell H2.
Insert this formula in I2 and copy across through J2:N2.

=INDEX($A$1:$G$8,MATCH($H2,$A$1:$A$8),COLUMN(B2))
I have used 6 columns of data as per your original posting, rather than
the three you show in this later posting.
--
Regards

Roger Govier


"Chris Adolph" wrote in message
...
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