Excel Data Extraction and List (Roulette/Casino)

Hi guys,

This is probably an easy one but after an hour or so of fiddling and googling, I cant seem to find the solution.

I work at a casino and I am trying to figure a promotion.

I have a simple sheet that has list of names each with three of their chosen numbers between 0 and 36.

On three occasions during a day we spin a roulette wheel to get the 3 random numbers and those that match the numbers wins a prize. (1=£5, 2=£25, 3=£500)

I have figured how to do this (probably using a long winded way) but I really wanted to have it be able to extract the winners onto a seperate page (or on same page but offset).

I have it so it currently displays their winnings for each round and im trying to figure a way of using that notice to extract. (something like, IF=this cell has "£25" then put HERE in a tidy list along with the name that is 2 cells to the left of it)

I am hoping someone can help me, my brain is turning to mush!

Many thanks, and I hope this makes some sense.