V Look Up where multiple values MIGHT be the same

Hi

I currently have a spread sheet that uses a LARGE function to find the top 5 most expensive items in my data set. These values come from when another worksheet is filled in every quarter and automatically populate, so will change over time.

In the next column, I've used a VLOOKUP to find the description of what that item.

However, if there are 2+ items that cost the same, VLOOKUP will only bring up the description of the first item on the sheet.

I've looked through threads but I haven't found anything similar to this yet, the suggestions of using array formulas with IF and SMALL etc don't seem to work because they rely on giving the rows the repeated look up value is in, and as it will change every quarter this isn't feasible.

My worksheet will ideally look something like this:
(but using the VLOOKUP, it would say "t-shirt" next to every £50 because the first £50 in the data set is a t-shirt)

Q1 | £50 | t-shirt
| £40 | skirt
Q2 | £50 | trainers
| £60 | coat
Q3 | £20 | sunglasses
| £50 | jeans
Q4 | £15 | t shirt
| £30 | heels
-----------------------------------
Top 5 | £60 | coat
| £50 | t-shirt
| £50 | trainers
| £50 | jeans
| £40 | skirt


Any ideas?

Thanks!

sorry didn't realise the lines I used for columns would do that when it posted!

It would help if you attached a sample Excel workbook.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post. Don't try to use the Paperclip icon (Attachments button), as it doesn't work on this forum.

Hope this helps.

Pete