Array Help - World cup pool

Hi. I have a possible array question, if in case an array is the most
appropriate.

I have a persons team selections that will proceed to second round in
sheet1( A1,B1,C1,D1). If any of the persons team selection matches my
worksheet with my games stats(sheet2) than give them 10 pts.
Format of the games stats is:

Second round
team vs. team
M1 Q1
M2 Q2
M3 Q3

So if any of the persons selection in Sheet1(a1,b1,c1,d1) matches [M1:M3 OR
Q1:Q3] (sheet2) than give them 10 pts.

Thanks for the help
Chris.

Hi!

Try this:

Do you mean to calculate 10 points FOR EACH MATCH?

=SUMPRODUCT(--(ISNUMBER(MATCH(A1:D1,M1:M3,0))+ISNUMBER(MATCH(A1:D1,Q1:Q3,0))))*10

Biff

"ChristopherH" <[email protected]> wrote in message
news:[email protected]...
> Hi. I have a possible array question, if in case an array is the most
> appropriate.
>
> I have a persons team selections that will proceed to second round in
> sheet1( A1,B1,C1,D1). If any of the persons team selection matches my
> worksheet with my games stats(sheet2) than give them 10 pts.
> Format of the games stats is:
>
> Second round
> team vs. team
> M1 Q1
> M2 Q2
> M3 Q3
>
> So if any of the persons selection in Sheet1(a1,b1,c1,d1) matches [M1:M3
> OR
> Q1:Q3] (sheet2) than give them 10 pts.
>
> Thanks for the help
> Chris.

Sweet. That works.

Thanks,
Chris

Go Germany!

"Biff" wrote:

> Hi!
>
> Try this:
>
> Do you mean to calculate 10 points FOR EACH MATCH?
>
> =SUMPRODUCT(--(ISNUMBER(MATCH(A1:D1,M1:M3,0))+ISNUMBER(MATCH(A1:D1,Q1:Q3,0))))*10
>
> Biff
>
> "ChristopherH" <[email protected]> wrote in message
> news:[email protected]...
> > Hi. I have a possible array question, if in case an array is the most
> > appropriate.
> >
> > I have a persons team selections that will proceed to second round in
> > sheet1( A1,B1,C1,D1). If any of the persons team selection matches my
> > worksheet with my games stats(sheet2) than give them 10 pts.
> > Format of the games stats is:
> >
> > Second round
> > team vs. team
> > M1 Q1
> > M2 Q2
> > M3 Q3
> >
> > So if any of the persons selection in Sheet1(a1,b1,c1,d1) matches [M1:M3
> > OR
> > Q1:Q3] (sheet2) than give them 10 pts.
> >
> > Thanks for the help
> > Chris.
>
>
>

You're welcome. Thanks for the feedback!

Biff

"ChristopherH" <[email protected]> wrote in message
news:[email protected]...
> Sweet. That works.
>
> Thanks,
> Chris
>
> Go Germany!
>
> "Biff" wrote:
>
>> Hi!
>>
>> Try this:
>>
>> Do you mean to calculate 10 points FOR EACH MATCH?
>>
>> =SUMPRODUCT(--(ISNUMBER(MATCH(A1:D1,M1:M3,0))+ISNUMBER(MATCH(A1:D1,Q1:Q3,0))))*10
>>
>> Biff
>>
>> "ChristopherH" <[email protected]> wrote in message
>> news:[email protected]...
>> > Hi. I have a possible array question, if in case an array is the most
>> > appropriate.
>> >
>> > I have a persons team selections that will proceed to second round in
>> > sheet1( A1,B1,C1,D1). If any of the persons team selection matches my
>> > worksheet with my games stats(sheet2) than give them 10 pts.
>> > Format of the games stats is:
>> >
>> > Second round
>> > team vs. team
>> > M1 Q1
>> > M2 Q2
>> > M3 Q3
>> >
>> > So if any of the persons selection in Sheet1(a1,b1,c1,d1) matches
>> > [M1:M3
>> > OR
>> > Q1:Q3] (sheet2) than give them 10 pts.
>> >
>> > Thanks for the help
>> > Chris.
>>
>>
>>