On Sat, 18 Apr 2009 11:54:06 -0700, "Questor"
wrote:

Thanks Ron, that helps. I'm still having trouble understanding why the
LOOKUP function is returning unexpected results. You can contact me at
to arrange to obtain a simple file that demonstrates the
problem if you wish.
Again, thanks

I'll guess that either your data is not what you think it is (text vs numbers)
or you have not read HELP for the LOOKUP function? In particular,

" Important: The values in lookup_vector must be placed in ascending order:
.... otherwise, LOOKUP might not return the correct value. Uppercase and
lowercase text are equivalent."

You've mentioned nothing about having sorted your data.

I would suggest that you append to your data a column with the unique rankings
for the salespeople, generated as per Chip's web site; and then use something
like (not tested)

=INDEX($A$1:$A$100,MATCH(N1,$G$1:$G$100,0))

assuming column G contains your rankings; column A contains your sales people
names, and N1 contains the rank you are looking for.
--ron