NCAA March Madness Squares

[keenannamkung]

Some of you may have played this before....

I am running a pool for the tournament and here is my question.

I have a 10x10 grid where names will be filled in and random numbers from 0 - 9 will be filled in for the columns & rows.

for example
Columns = Winner score 58
Rows = Loser score. 55

so if say Mike's name is in column 8 and row 5, he wins the $ for that game in the round.

payout structure shown below.
[TABLE="width: 624"]
<tbody>[TR]
[TD]round[/TD]
[TD]Round.[/TD]
[TD]Games[/TD]
[TD]Payout[/TD]
[TD]Total Payout[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1st Round[/TD]
[TD]32[/TD]
[TD] $ 10[/TD]
[TD] $ 320[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2nd Round[/TD]
[TD]16[/TD]
[TD] $ 20[/TD]
[TD] $ 320[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Regional Semifinals[/TD]
[TD]8[/TD]
[TD] $ 40 [/TD]
[TD] $ 320 [/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Regional Finals[/TD]
[TD]4[/TD]
[TD] $ 80[/TD]
[TD] $ 320[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Final 4[/TD]
[TD]2[/TD]
[TD] $ 160[/TD]
[TD] $ 320[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]National Championship[/TD]
[TD]1[/TD]
[TD] $ 400[/TD]
[TD] $ 400[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]63[/TD]
[TD][/TD]
[TD] $ 2,000[/TD]
[/TR]
</tbody>[/TABLE]


Lets say I have a table with
[TABLE="width: 500"]
<tbody>[TR]
[TD]Winner Name[/TD]
[TD]W Digit[/TD]
[TD]L Digit[/TD]
[/TR]
[TR]
[TD]Tom[/TD]
[TD]9[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]Mike[/TD]
[TD]6[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Jake[/TD]
[TD]5[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Jim[/TD]
[TD]5[/TD]
[TD]8[/TD]
[/TR]
</tbody>[/TABLE]


what formula do i need for the winner's name to show up on the far right column? i am thinking a combo of index, match, vlookup? but i do not know where to start =(


[TABLE="width: 500"]
<tbody>[TR]
[TD]Round[/TD]
[TD][/TD]
[TD]Payout[/TD]
[TD]Winner[/TD]
[TD]Loser[/TD]
[TD]Winner Score[/TD]
[TD]Loser Score[/TD]
[TD]W Digit[/TD]
[TD]L Digit[/TD]
[TD]Winner Name[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1st Round[/TD]
[TD]$10[/TD]
[TD]a[/TD]
[TD]b[/TD]
[TD]99[/TD]
[TD]97[/TD]
[TD]9[/TD]
[TD]7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1st Round[/TD]
[TD]$10[/TD]
[TD]c[/TD]
[TD]d[/TD]
[TD]66[/TD]
[TD]54[/TD]
[TD]6[/TD]
[TD]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1st Round[/TD]
[TD]$10[/TD]
[TD]e[/TD]
[TD]f[/TD]
[TD]55[/TD]
[TD]54[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]1st Round[/TD]
[TD]$10[/TD]
[TD]g[/TD]
[TD]h[/TD]
[TD]65[/TD]
[TD]58[/TD]
[TD]5[/TD]
[TD]8[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Thank you all

 

[Scott T]

[TABLE="class: grid, width: 400"]
<tbody>[TR="bgcolor: #DCE6F1"]
[TD][/TD]
[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD="align: center"]C
[/TD]
[TD="align: center"]D
[/TD]
[TD="align: center"]E
[/TD]
[TD="align: center"]F
[/TD]
[TD="align: center"]G
[/TD]
[TD="align: center"]H
[/TD]
[TD="align: center"]I
[/TD]
[TD="align: center"]J
[/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]1
[/TD]
[TD]Winner Name
[/TD]
[TD]W digit
[/TD]
[TD]L Digit
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]2
[/TD]
[TD]Tom
[/TD]
[TD]9
[/TD]
[TD]7
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]3
[/TD]
[TD]Mike
[/TD]
[TD]6
[/TD]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]4
[/TD]
[TD]Jake
[/TD]
[TD]5
[/TD]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]5
[/TD]
[TD]Jim
[/TD]
[TD]5
[/TD]
[TD]8
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]6
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]7
[/TD]
[TD]Round
[/TD]
[TD]Payout
[/TD]
[TD]Winner
[/TD]
[TD]Loser
[/TD]
[TD]Winner Score
[/TD]
[TD]Loser Score
[/TD]
[TD]W digit
[/TD]
[TD]L Digit
[/TD]
[TD]Winner Name
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]8
[/TD]
[TD]1st round
[/TD]
[TD]$10[/TD]
[TD]a[/TD]
[TD]b[/TD]
[TD]99[/TD]
[TD]97[/TD]
[TD]9[/TD]
[TD]7[/TD]
[TD]Tom[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]9
[/TD]
[TD]1st round
[/TD]
[TD]$10[/TD]
[TD]c[/TD]
[TD]d[/TD]
[TD]66[/TD]
[TD]54[/TD]
[TD]6[/TD]
[TD]4[/TD]
[TD]Mike[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]10
[/TD]
[TD]1st round
[/TD]
[TD]$10[/TD]
[TD]e[/TD]
[TD]f[/TD]
[TD]55[/TD]
[TD]54[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD]Jake[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="bgcolor: #DCE6F1"]11
[/TD]
[TD]1st round
[/TD]
[TD]$10[/TD]
[TD]g[/TD]
[TD]h[/TD]
[TD]65[/TD]
[TD]58[/TD]
[TD]5[/TD]
[TD]8[/TD]
[TD]Jim[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

This is an array formula you must enter it with CONTROL+SHIFT+ENTER If done properly excel will but {} around the formula in the formula bar. Then copy down

=INDEX($A$2:$A$5,MATCH(G8&H8,$B$2:$B$5&$C$2:$C$5,0))