=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