Hi
all you have to do is replace the "searching" cell with your result:
Say you choose Index, Search cell in bold:
=INDEX(Sheet1!$A$1:$C$10,MATCH(A1,Sheet1!$A$1:$A$10,0),2)
this as explained would look to match what was in cell A1.
So in Sheet2, in column A, you have A1 Largest, A2 2nd largest ....
(this can be done with as you said)
replace what you look for in the function A1 = INDEX('PRIZE POOL'!$A$1:$C$10,MATCH(LARGE('PRIZE POOL'!E9:E58,2)
, 'PRIZE POOL'!$A$1:$A$10,0),2)
OR in B1 write =INDEX('PRIZE POOL'!$A$1:$C$10,MATCH(A1,'PRIZE POOL'!$A$1:$A$10,0),2)
(I replaced sheet1 with PRIZE POOL)...