Find second highest value, return different column value

[ste33uka]

Hi would anyone have a formula that would find the second highest value and return different column.
So as in example would give answer apple.

Book1
	A	B	C	D	E
1
2
3
4	1				PEAR
5	5				ORANGE
6	3				APPLE
7	4				PEAR
8	12				ORANGE
9	6				APPLE
10	11				APPLE
11	5				PEAR
12
13
14
Sheet1

 

[Fluff]

How about

=INDEX(E4:E11,MATCH(LARGE(A4:A11,2),A4:A11,0))

 

[ste33uka]

How about

=INDEX(E4:E11,MATCH(LARGE(A4:A11,2),A4:A11,0))

Thanks, is there a method possible with duplicate ?
So as in example the 2nd and 3rd highest value would return pear and apple in any order ? instead or just pear .

Book1
	A	B	C	D	E	F	G	H	I
1
2
3
4	1				PEAR		1st highest	bananna
5	2				ORANGE		2nd highest	pear
6	3				APPLE		3rd highest	pear
7	4				PEAR		4th highest	ORANGE
8	5				ORANGE
9	7				pear
10	7				APPLE
11	8				bananna
12
13
14
15
16
Sheet1

Cell Formulas
Range	Formula
H4	H4	=INDEX(E4:E11,MATCH(LARGE(A4:A11,1),A4:A11,0))
H5	H5	=INDEX(E4:E11,MATCH(LARGE(A4:A11,2),A4:A11,0))
H6	H6	=INDEX(E4:E11,MATCH(LARGE(A4:A11,3),A4:A11,0))
H7	H7	=INDEX(E4:E11,MATCH(LARGE(A4:A11,4),A4:A11,0))

 

[Fluff]

Are you going to make any further changes to your requirements?

 

[ste33uka]

Are you going to make any further changes to your requirements?

sorry completly forgot about duplictes, no cant think of anything else to add.

 

[Fluff]

Ok, how about

+Fluff New.xlsm
	A	B	C	D	E	F	G	H	I
1
2
3
4	1				PEAR		1st highest	8	bananna
5	2				ORANGE		2nd highest	7	pear
6	3				APPLE		3rd highest	7	APPLE
7	4				PEAR		4th highest	5	ORANGE
8	5				ORANGE
9	7				pear
10	7				APPLE
11	8				bananna
12
Main

Cell Formulas
Range	Formula
H4:H7	H4	=LARGE($A$4:$A$11,ROWS(H$4:H4))
I4:I7	I4	=INDEX($E$4:$E$11,AGGREGATE(15,6,(ROW($E$4:$E$11)-ROW($E$4)+1)/($A$4:$A$11=H4),COUNTIFS(H$4:H4,H4)))

 

[ste33uka]

Thanks ill give it a go