Vlookup Duplication Issues

[daveyk72]

Hi all,

This is my first post on this forum so please be gentle!

I am using a 'LARGE' formula to list the top 5 from my spreadsheet and when I do a Vlookup to bring back the results, I notice that there are two '3' listed and two '1's , therefore get a duplicate answer. E.g. see below:



How can I run a Vlookup with no duplications?

Thanks

Dave

 

[Hui]

Have you read:
http://chandoo.org/wp/2014/12/09/multiple-occurrences-lookup-and-extraction/