View Single Post
  #1   Report Post  
 
Posts: n/a
Default Multiple Reference Lookup

I'm trying to generate a little spreadsheet that will determine the
winning results for the lottery for a list of tickets. I have a
winnings rule table:

B1-5 PB
5 1 340000000
5 0 200000
4 1 10000
4 0 100
3 1 100
3 0 7
2 1 7
1 1 4
0 1 3

I also have a table of the ticket numbers, that count the match
occurances in the draw numbers. I'm having trouble figuring out how to
do a lookup and index of the various combinations defined in the table
so as to return the payout values.

e.g. 3, 1 = 100

Thanks!