Rank and Vlookup N/A issue

Hi all,

Hope your all ok.

scores.xls

I have the score sheet attached.

I have managed to rank all my scores via Total scored.
This is fine as the rank lists 25 teams and where there is a draw it just says 17 for example.

The issue comes below when I have linked VLookup with the rank list.
As im using false it returns N/A and when i change it to try it just says I have loads of Team 6 for example.

My question is: If somebody has the same score how do I make the vlookup still count the next team or something?

thanks

Martin

perfect. thats works great
thanks