Looking for help...

[Chris Adolph]

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,

 

[Bob Phillips]

=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]

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
[email protected]

=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)

 

[Teethless mama]

Take a look Advanced Filter in Excel Help menu

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,

 

[BoniM]

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!

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,

 

[Roger Govier]

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

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,