Lookup 1st , 2nd , 3rd Maximum value

[skhaliq]

Data
Names	SKU1	SKU2	SKU3	SKU4	SKU5
Ali	0	20	15	0	0
Butt	15	0	16	30
Adnan	0	25	15	10	15

<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>

Name	Result
Ali	20
Ali	15
Butt	?
Butt	?
Butt	?
Adnan	?
Adnan	?
Adnan	?
Adnan	?

<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[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.