Okay, this is a challenge to all of you excel wizards out there. If
you can figure this out, well, I'll be impressed. Here it is:

The first worksheet in my workbook I have the master information that I
am collecting (I called this worksheet "Master"). This information has
two columns, one is alpha and the other numeric. Also in this
worksheet I add up the number of "correct answers" for each worksheet
(lets call them two, three, four, etc.) and give a point for each
correct answer for each problem. Column D is worksheet two's score for
the problem, Column E is worksheet three's score for the problem, and
so on. A correct answer is worth one point, all others are worth zero.

Row 1 is problem 1, Row 2 is problem 2, and so on. Lets say in column
A is my alpha column. In cell A1 I have the word "Sell". Column B is
my numeric column. In cell B1 I have the value "20".

In a worksheet two, A1 reads "Buy" and B1 reads "10".
In worksheet three, A1 reads "Sell" and B1 reads "22".
In worksheet four, A1 reads "Sell" and B1 reads "10".

Because worksheet four gave the correct alpha value AND had the closest
numeric value (without going over) it should be provided a point for
providing the correct answer for problem 1. This means the value for
cell F1 in the master worksheet should reflec this and read "1".
Alright, does anyone have any idea?