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!
|