Checking Lotto numbers

[JockW]

Numbers to be checked - A4:F10
Draw numbers - A12:F12

I have tried (in I4) {=IF($A4:$F4=A12,"P","")} which works but only because
the criteria is met in the first column. When copied down and accross it
doesn't work.
Any ideas?

 

[Max]

In I4, copied down to I10:
=SUMPRODUCT(--(ISNUMBER(MATCH(A4:F4,A$12:F$12,0))))
will return the number of matched/winning numbers in each row

 

[T. Valko]

Try this:

Select the range A4:F10
Goto the menu Format>Conditional Formatting
Formula Is:

=AND(A4<>"",OR(A4=$A$12:$F$12))

Click the Format button
Select the Patterns tab
Select a nice shade of green
OK out

 

[Rick Rothstein \(MVP - VB\)]

This seems to work also...

=MATCH(A4,$A$12:$F$12,0)

Rick

 

[JockW]

Thanks to all. Not tried any yet but will do.
Cheers.