Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Return cell reference of lookup value | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Multiple reference for lookup in excel | Excel Worksheet Functions | |||
Multiple reference for lookup in excel | Excel Worksheet Functions | |||
How do I reference multiple rows | Excel Worksheet Functions |