Does the formula return any results at all, or are you just having
trouble compiling them?

In the lookup table, are the Female and Male awards listed separate
(ie. first all Male lookups, then perhaps underneath all Female
lookups, or are they intermingled).

Are the scores in the table, just a bottom range and so the actual
scores can be anything between the scales in the lookup or the actual
scores are available exactly as they are in the lookup table?

These things are necessary to know in order to understand what you
need.


If you want me to take a look at the sheet send me your e-mail in a
private message and I will send you mine back.


--
Vito
------------------------------------------------------------------------
Vito's Profile: http://www.excelforum.com/member.php...o&userid=29182
View this thread: http://www.excelforum.com/showthread...hreadid=489900