Help with excel
 

Basically I'm trying to tell excel to reference to another worksheet to figure out how many qualification points a team should get. To get a basic idea, this is what I have so far :http://www.chiefdelphi.com/media/papers/1914
Any hep would be much appreciated.

Nick~1334/:yikes: :) :confused: :eek: :mad:

Re: Help with excel
 

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

Re: Help with excel
 

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.

Re: Help with excel
 

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

~Nick/1334

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.

Re: Help with excel
 

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.

Re: Help with excel
 

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.