Lookup return multiple values for a list

[MissSpreadsheets]

Hi,

I need help with returning multiple values from a lookup. The data to the left is the source data for 1000s of rows that contain duplicates.
I would like the result to be something on the right (again this will be for 100s of cells) e.g. show the top 7 items (using the Large formula, this I can do), however in the fruit and veg columns it needs to return all that had 50.

I've found plenty of these solutions (How To Return Multiple Match Values in Excel Using INDEX-MATCH or VLOOKUP) (uses small formula) but this only works for one lookup for one item, whereas after returning all the ones with 50, it needs to return all the ones with 40 etc. in the same list.

Hope someone can help, thanks,

Number	Fruit	Vegetable				Largest	Fruit	Vegetable
50	Orange	Carrot			1	50	Orange	Carrot
40	Apple	Peas			2	50	Banana	Onion
18	Kiwi	Broccoli			3	50	Orange	Pepper
40	Pineapple	Potato			4	40	Apple	Peas
50	Banana	Onion			5	40	Pineapple	Potato
50	Orange	Pepper			6	23	Peach	Parsnip
23	Peach	Parsnip			7	18	Kiwi	Broccoli

<tbody>
</tbody>