G

#### Guest

I have a pivot table with the following data:

Apples $1,000

Bananas $1,000

Pears $1,000

Oranges $500

Peaches $450

Using the "LARGE" formula, I am pulling the 3 largest values of $1,000. I

need to match the name to the value, but my formula is duplicating the first

name 3 times so it looks like this:

apples $1,000

apples $1,000

apples $1,000

How do I get the formula to recognize there are 3 different names?

My formula:

=INDEX($C$13:$C$65536,MATCH($E$10,$F$13:$F$65536,0))

Any help is greatly appreciated!! Thanks!