Put an E helper column in sheet1 which repeats column A

In your example:

Worksheet 1
Column A B C D E
SOLD Week 1 Week 2 Total Sold E

Oranges 2 3 5 =A3
Pears 0 1 1 =A4
Apples 5 5 10 =A5


On Worsheet 2, :

Highest Sold:
column A B
=VLOOKUP(B3;Sheet1!D$3:E$5;2;FALSE) =LARGE(Sheet1!D$3:D$5;1)
=VLOOKUP(B4;Sheet1!D$3:E$5;2;FALSE) =LARGE(Sheet1!D$3:D$5;2)
=VLOOKUP(B5;Sheet1!D$3:E$5;2;FALSE) =LARGE(Sheet1!D$3:D$5;3)
Regards,
Stefi