Thread: excel help
View Single Post
Old 06-07-2007, 21:50   #6 (permalink)
aliando
-
 
Join Date: 12 Aug 2005
Age: 32
Posts: 21,013
Awards Showcase
Daily Horse Racing Competition Top Class Glory Hunter European & Worldwide Competition Supercup (I) European & Worldwide Competition KO Cup 
Total Awards: 5
Default Re: excel help
p35 - =INDEX(A2:C25,MATCH("team02",A2:A25,0),3)

s35 - =IF(R35=3,"3",IF(R35=1,"1",IF(R35=0,"-1")))


sorry mate - didnt realise that would make the difference, so didnt mention it first time round.

the above 2 are working fine.
__________________
the charity trail-http://www.punterslounge.com/forum/s...d=1#post631758

Quote:
I am the most anti-social person I know. But of course, I don't know anyone because I'm so anti-social. Derek Neitzel.
aliando is offline   Reply With Quote