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! |
#2
|
|||
|
|||
Multiple Reference Lookup
Assuming the above data runs in ranges a2:10, b2:10 and c2:10
respectively, and the two parts to the ticket combination are in A13 and B13, the following formula performs the lookup: =INDEX(C2:C10,MATCH(A13&B13,A2:A10&B2:B10,FALSE)) It is an array formula, so you will need to ctrl+alt+enter after you type it an a cell. Regards, Sam |
Reply |
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 |