Required horizontal data

[Rahul Mishra]

Dear Sir,

I have attached one excel sheet in this i required data in yellow color highlighted by excel formula

 

[bosco_yip]

Try,

In G12, formula copied across and down :

=IFERROR(INDEX($C$1:$C$9,AGGREGATE(15,6,ROW($A$1:$A$9)/($B$1:$B$9=RIGHT($F12,3)),COLUMNS($A:A))),"")

Regards
Bosco

 

[Rahul Mishra]

dear sir thanks for reply but i request to you please provide me any small and easy way for it so that i can understand.