Making a top ten list?

Hello, this is my first post and I'm trying to create a top ten list of the most used products from my stores inventory. I have the names of each product going down one column and the amount used going down another. I can very easily find the top ten using the LARGE formula but I am unable to connect the names of the products in the other column to these values. I only have an average understanding of excel and am in need of help. Thanks for any input!

Justin

can you upload example workbook with your input and desired output?

I've attached an example of what I'm trying to do to this comment. In my actual spreadsheet the names of the products aren't right next to the values but a few columns over, lined up on the same rows though.

How about adding filter in 1st row and sort by Value column?

That would rank all your values from highest to lowest and not only first 10.

In case of top 10 you can you use this with one helper column C

(you can hide that column and it's needed for check there if there is more products with same value).