=IF(ISERROR(VLOOKUP(RANK(C5,C$1:C$8),G$1:H$5,2,FAL SE)),0,VLOOKUP(RANK(C5,C$1:C$8),G$1:H$5,2,FALSE))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Saxman" wrote in message
...
I have the following figures in columns C,D,G and H with the following
function in
C1.

=IF(ISERROR(VLOOKUP(RANK(C1,C$1:C$8),G$1:H$5,2,FAL SE)),"",VLOOKUP(RANK(C1,C$1:C$8),G$
1:H$5,2,FALSE))

C D G H
82 25 1 25
72 20 2 20
71 15 3 15
68 10 4 10
63 5 5 5
53
52
45

Column D awards points according to rank in column C (top 5).
How can I alter the function so that anything that does not score in the
top 5 gets
awarded a zero?

TIA
--