Help with excel

[Pavan Dave]

Originally Posted by Setsanto

Yes, thats what i was hoping on doing. What should I do to change that?

Sorry I read it wrong. I thought u wanted individual scoring rather than just the RP and QP of each team. I see what you want to do now. I am working on it right now. It has to do with your box. I am trying to make it to

EDIT: I can get =IF(IF(68=Sheet1!T25,Sheet1!U17,0),(IF(68=Sheet1!U 25,Sheet1!U17,0))) to work but anything beyond that isnt working the least bit. Ill work on it later tonight.

Pavan.

[Setsanto]

Ok, thanks a lot for the help, I really appreciate it

~Nick/1334

[kramarczyk]

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.

[Pavan Dave]

That is exactly what I was thinking. I was thinking you would have to macro it because the way it is formatted right now it will only work for one sheet for one match at a time making his whole set up kind of useless. Maybe if he wanted to do it similarly without a macro he could make about 50 matches or rounds worth of records but I beileve what you suggested would be the best. Thanks for helping.

Pavan.

Pavan.

[Setsanto]

I decided to abandon excel if statements last night and went straight to VB code. So thanks for all your help, I think I've got it now.