Thread: Help with excel
View Single Post
  #5   Spotlight this post!  
Unread 30-01-2007, 22:18
kramarczyk's Avatar
kramarczyk kramarczyk is offline
is getting his kicks.
AKA: Mark Kramarczyk
FRC #3096 (Highlanders)
Team Role: Mentor
  
Join Date: Mar 2006
Rookie Year: 2006
Location: Sterling Heights, MI
Posts: 602
kramarczyk has a reputation beyond reputekramarczyk has a reputation beyond reputekramarczyk has a reputation beyond reputekramarczyk has a reputation beyond reputekramarczyk has a reputation beyond reputekramarczyk has a reputation beyond reputekramarczyk has a reputation beyond reputekramarczyk has a reputation beyond reputekramarczyk has a reputation beyond reputekramarczyk has a reputation beyond reputekramarczyk has a reputation beyond repute
Re: Help with excel
How about

=IF(OR(Sheet3!B2=Sheet1!$T$25,B2=Sheet1!$U$25,Shee t3!B2=Sheet1!$V$25),Sheet1!$U$17,IF(OR(Sheet3!B2=S heet1!$T$26,B2=Sheet1!$U$26,Sheet3!B2=Sheet1!$V$2) ,Sheet1!$U$20,0))

Assumptions:
That this will only be used to track one match at a time. If you want to collect across sheets then a VB macro is probably in order. I think I have something similar from last year that can be recycled.