Help with VLOOKUP, PLEASE!!!

[nander]

I have an flyer quiz incentive program that works like this.
$10 per participant per month in a monthly pool
$10 per participant per quarter in a quarterly pool.
$10 if someone gets a perfect score (if 2 people get a perfect scor
they split the monthly pot and the $10.)
The quarterly pot goes to the employee(s) with the highest quarterl
score.
Each month there's a prize for the highest monthly score and eac
quarter ther's an additional prize for the highest quarterly prize. Fo
example, if I had 3 employees each month participate, the monthly priz
would be $30. ($10X3), the quarterly prize would be $90 ($10x3x3).

I'd like some help organizing the data in the worksheet. I've attache
the spreadsheet. What I'd like to do is use VLOOKUP in the Winner rang
looking at the scores in the TEST SCORE range using the criteria above
If an employee does not participate the Pot decreases. I'd like th
Winner appear with the amount he will receive. If there is a tie th
amounts are split among the winner(s). Thank

+-------------------------------------------------------------------
|Filename: FLYER QUIZZ.zip
|Download: http://www.excelforum.com/attachment.php?postid=4587
+-------------------------------------------------------------------

 

[L. Howard Kittle]

I can't access your attachment. I would be willing to take a look at your
workbook.
Send to (e-mail address removed) along with details of what you want to happen.

Regards,
Howard