One way to set it up ..

Assuming the winning numbers will be entered in A1:F1 in Sheet1,
for example: 1, 15, 25, 38, 48, 49
(The numbers within A1:F1 need not be sorted, can be in any order)

And the picked #s are listed in Sheet2, in cols B to G, row1 down
4 15 20 28 35 49
1 15 25 38 47 48
6 15 25 38 41 49
etc

(as before, the numbers within each row need not be sorted)

Put in say, I1:
=SUMPRODUCT(--ISNUMBER(MATCH(B1:G1,Sheet1!$A$1:$F$1,0)))
Copy I1 down.

Col I will return the desired # of matched numbers
For the sample data, you'll get in I1:I3   :   2, 5, 4

Here's a file that does what you want.

Ticket Checker.xls  84kb

http://cjoint.com/?jneKqRchxY

It has a sheet for 5 numbers and one for 6 numbers. There is one very simple
macro that clears the number grid if you click the RESET button. It will
highlight and count any matches. It uses data validation so you won't make
any mistakes when you enter your numbers.

Biff

Here is an idea I used on the Texas Lottery until I decided NOT to play
anymore. Ripoff.

conditional format using formula to highlight the cell
=SUMPRODUCT(($B$5:$F$5=B9)*1)
& copy across
to count
=IF(G9=0,"",SUMPRODUCT(COUNTIF(B9:F9,$B$5:$F$5)))
with conditional formatting cell value is >=4