Howdy,

When Powerball gets up to the $200 million mark, we start pooling up money
at work and buying a bunch of tickets. I want to make a spreadsheet where I
can type in all the numbers we buy and then enter the numbers drawn and have
it calculate the winnings for us.

I figured it'd be pretty simple but don't know how to get started.

If I type in the winning numbers into 6 cells, I could then query the table
data looking for a match to those numbers in the sample data. Could I then
turn the background to red or something to flag them all?

After that can I do some sort of other lookup that would go row by row and
see how many red cells there are and count them somehow?

Any help and advice would be great.