Another IF question

[Blair]

I am trying to create a spreadsheet to keep track of Lottery Numbers (this
is just for fun, so I don't need a commercial program) and so far I'm stuck
trying to figure out how to have more than 1 number in my formula reference.
I am using 10 sets of 6 numbers, but only using a total of 10 numbers to
create these 10 sets. For example this is the formula I am using to check
just 1 number,

=IF(A15=X,"MATCH",0)

X is one of the lottery numbers. I'd like to be able to put in more than 1
of the lottery numbers I'm using in this formula.

I've tried using nested function, but of course I can only go up to seven
numbers. IF Excel allowed 10 , I'd be home free. Is
there an easier way?

Thanks in advance,
Blair

 

[Biff]

Hi Blair,

Would need to know how your data is layed out. I also do
quite a bit of lottery crunching. In fact I had a winner
today!<VBG>

If your interested, I have a workbook I could send you
that may give you some ideas.

Biff