Formula to read values from a range to and autopopulate info into 2 different columns

[HeyItsDizzy]

Hi Guys. I am new to this forum, and not sure how to place my actual excel cells in here...

Ok. So I will explain as best I can, I am after a formula (not a macro) to Take player preference and auto-generate a list; in this example, there are only 2 rewards and only 5 rewards available each.

so the players with the highest score will get to pick their preferred prize first.
However as you can see (in column B) 7 players want the Puppy, And only 3 want the Dinosaur
if each person took their prize one by one in order of their high scores the player reward handouts would like they do in columns E and F

I have assigned a Value number to the type of prize for use with a Vlookup function, or any other formula that will read those numbers as a value/code type thing, (I also know that Vlookup only work from left to right and will not go backwards, therefore I am happy to duplicate the name columns, and reward type columns etc if need be so that a formula such as that will work

I don't mind how many separate calculations/columns and/or rows need to be placed (i can make another cell array if that is also required)

I would just like to know the best way to get my 'A2:C11' range looking like my 'E:F' column range based on the placement results

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD="align: center"][/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]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD="align: center"]Name[/TD]
[TD="align: center"]Pref type[/TD]
[TD="align: center"]Pref Value[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Puppy[/TD]
[TD="align: center"]Dinosaur[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: center"]Dizzy[/TD]
[TD="align: center"]Puppy[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Dizzy[/TD]
[TD="align: center"]Arvo[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: center"]Zenaku[/TD]
[TD="align: center"]Puppy[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Zenaku[/TD]
[TD="align: center"]BeginJehan[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: center"]Arvo[/TD]
[TD="align: center"]Dinosaur[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[TD="align: center"]BennyBoo[/TD]
[TD="align: center"]BetterQuad[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: center"]BeginJehan[/TD]
[TD="align: center"]Dinosaur[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[TD="align: center"]BennyBwoy[/TD]
[TD="align: center"]Cubosh[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: center"]Bennyboo[/TD]
[TD="align: center"]Puppy[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"]Corzza[/TD]
[TD="align: center"]HadLowJ[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: center"]BennyBwoy[/TD]
[TD="align: center"]Puppy[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: center"]BetterQuad[/TD]
[TD="align: center"]Dinosaur[/TD]
[TD="align: center"]2[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: center"]Corzza[/TD]
[TD="align: center"]Puppy[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: center"]Cubosh[/TD]
[TD="align: center"]Puppy[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD="align: center"]HadLowJ[/TD]
[TD="align: center"]Puppy[/TD]
[TD="align: center"]1[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]