Lookup 1st , 2nd , 3rd Maximum value

[skhaliq]

[TABLE="width: 384"]
<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl64, width: 64, align: center"]Data[/TD]
[TD="width: 64, align: center"][/TD]
[TD="width: 64, align: center"][/TD]
[TD="width: 64, align: center"][/TD]
[TD="width: 64, align: center"][/TD]
[TD="width: 64, align: center"][/TD]
[/TR]
[TR]
[TD="class: xl63, align: center"]Names[/TD]
[TD="class: xl63, align: center"]SKU1[/TD]
[TD="class: xl63, align: center"]SKU2[/TD]
[TD="class: xl63, align: center"]SKU3[/TD]
[TD="class: xl63, align: center"]SKU4[/TD]
[TD="class: xl63, align: center"]SKU5[/TD]
[/TR]
[TR]
[TD="class: xl63, align: center"]Ali[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"]15[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]0[/TD]
[/TR]
[TR]
[TD="class: xl63, align: center"]Butt[/TD]
[TD="align: center"]15[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]16[/TD]
[TD="align: center"]30[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="class: xl63, align: center"]Adnan[/TD]
[TD="align: center"]0[/TD]
[TD="align: center"]25[/TD]
[TD="align: center"]15[/TD]
[TD="align: center"]10[/TD]
[TD="align: center"]15[/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Name[/TD]
[TD="width: 64"]Result[/TD]
[/TR]
[TR]
[TD]Ali[/TD]
[TD="class: xl65"]20[/TD]
[/TR]
[TR]
[TD]Ali[/TD]
[TD="class: xl65"]15[/TD]
[/TR]
[TR]
[TD]Butt[/TD]
[TD="class: xl65"]?[/TD]
[/TR]
[TR]
[TD]Butt[/TD]
[TD="class: xl65"]?[/TD]
[/TR]
[TR]
[TD]Butt[/TD]
[TD="class: xl65"]?[/TD]
[/TR]
[TR]
[TD]Adnan[/TD]
[TD="class: xl65"]?[/TD]
[/TR]
[TR]
[TD]Adnan[/TD]
[TD="class: xl65"]?[/TD]
[/TR]
[TR]
[TD]Adnan[/TD]
[TD="class: xl65"]?[/TD]
[/TR]
[TR]
[TD]Adnan[/TD]
[TD="class: xl65"]?[/TD]
[/TR]
</tbody>[/TABLE]

 

[Jon von der Heyden]

My very crude and swift mock-up; perhaps:

Excel 2010
	A	B	C	D	E	F	G	H	I	J
1		SKU1	SKU2	SKU3	SKU4	SKU5		Index	Name	Result
2	Ali	0	20	15	0	0		1	Ali	20
3	Butt	15	0	16	30			2	Ali	15
4	Adnan	0	25	15	10	15		1	Butt	15
5								2	Butt	16
6								3	Butt	30
7								1	Adnan	25
8								2	Adnan	15
9								3	Adnan	10
10								4	Adnan	15
Sheet1

Cell Formulas
Range	Formula
H2	=COUNTIF($I$2:I2,I2)
J2	{=INDEX($B$2:$F$4,MATCH(I2,$A$2:$A$4,0),SMALL(IF(INDEX($B$2:$F$4,MATCH(I2,$A$2:$A$4,0),0)>0,COLUMN($B$1:$F$1)-COLUMN(A2)),H2))}
Press CTRL+SHIFT+ENTER to enter array formulas.