You can try a variant on the ranking function

=RANK(B2,$B$2:$B$12)+COUNTIF($B$2:$B2,B2)-1
will add one to the 2nd onwards of each duplicated score.

Peter

"madmxx22277" wrote:

say I got a table like this
Bob 4
Charlie 7
George 4
Oliver 2
Henry 8

I am using the large command to get me the 3 lowest numbers, and using
vlookup to match the name up with it, so I should end up with
Oliver 2
Bob 4
George 4
but since the last ones are the same number I end up with,
Oliver 2
Bob 4
Bob 4

please help, is there a way I can have vlookup do its thing, but have it not
be equal to another vlookup cell?