Take a look Advanced Filter in Excel Help menu


"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