Help with getting unique output dependent on two data validation lists

I have two validation lists that work correctly. However, I need output lower in the worksheet that will produce unique data dependent on what is selected in the validation lists. I have attached a sample workbook of basic data of what I mean. Any and all suggestions would be appreciated.


Sample Book.xlsx

Ok, a follow up question for this. I want to apply a skins match to this spreadsheet. Each hole is worth a certain amount that can be changed by the user. Whoever wins each hole wins that skin for the hole. If there is a tie on the hole, the money carries over to the next hole. Is there a formula that can tell me the winner and how much that golfer won?

Below is the attached workbook. I know that Bob is the winner of the example by myself physically counting and doing the math. I need a formula to insert to find the monetary award for the winner. I have inserted a comment as to where the formula needs to be. Again the skins amount can be changed by the user and if a hole has a tie the amount for that hole carries over to the next hole.

SampleVlookupWithKey (1).xlsx

Whoever shoots the lowest on each individual hole wins the skin amount input. Each hole will have a winner unless there is a tie, and that amount must be carried over to the next hole. I need the amount won by each basically and then the highest subtracted by the lower to find the amount won. The $50 on there may not be correct it was just where I needed the answer. For example for Bob, Hole 1= 25, 2= 25, 3=25, 4=-25...etc.