Cell  Formula  C11  {=IFERROR(INDEX(C$3:C$7,MATCH($A11,$A$3:$A$7,0)),"")}  D11  {=IFERROR(INDEX(D$3:D$7,MATCH($A11,$A$3:$A$7,0)),"")}  E11  {=IFERROR(INDEX(E$3:E$7,MATCH($A11,$A$3:$A$7,0)),"")}  C12  {=IFERROR(INDEX(C$3:C$7,MATCH($A12,$A$3:$A$7,0)),"")}  D12  {=IFERROR(INDEX(D$3:D$7,MATCH($A12,$A$3:$A$7,0)),"")}  E12  {=IFERROR(INDEX(E$3:E$7,MATCH($A12,$A$3:$A$7,0)),"")}  C13  {=IFERROR(INDEX(C$3:C$7,MATCH($A13,$A$3:$A$7,0)),"")}  D13  {=IFERROR(INDEX(D$3:D$7,MATCH($A13,$A$3:$A$7,0)),"")}  E13  {=IFERROR(INDEX(E$3:E$7,MATCH($A13,$A$3:$A$7,0)),"")}  C14  {=IFERROR(INDEX(C$3:C$7,MATCH($A14,$A$3:$A$7,0)),"")}  D14  {=IFERROR(INDEX(D$3:D$7,MATCH($A14,$A$3:$A$7,0)),"")}  E14  {=IFERROR(INDEX(E$3:E$7,MATCH($A14,$A$3:$A$7,0)),"")}  C15  {=IFERROR(INDEX(C$3:C$7,MATCH($A15,$A$3:$A$7,0)),"")}  D15  {=IFERROR(INDEX(D$3:D$7,MATCH($A15,$A$3:$A$7,0)),"")}  E15  {=IFERROR(INDEX(E$3:E$7,MATCH($A15,$A$3:$A$7,0)),"")}  A19  {=IFERROR(INDEX($A$11:$A$15,MATCH($B19,$B$11:$B$15,0)),"")}  B19  {=IFERROR(INDEX($B$11:$B$15,SMALL(IF($B$11:$B$15<>"",ROW($B$11:$B$15)ROW($11:$11)+1),ROWS($11:11))),"")}  C19  {=IFERROR(INDEX(C$11:C$15,MATCH($B19,$B$11:$B$15,0)),"")}  D19  {=IFERROR(INDEX(D$11:D$15,MATCH($B19,$B$11:$B$15,0)),"")}  E19  {=IFERROR(INDEX(E$11:E$15,MATCH($B19,$B$11:$B$15,0)),"")}  A20  {=IFERROR(INDEX($A$11:$A$15,MATCH($B20,$B$11:$B$15,0)),"")}  B20  {=IFERROR(INDEX($B$11:$B$15,SMALL(IF($B$11:$B$15<>"",ROW($B$11:$B$15)ROW($11:$11)+1),ROWS($11:12))),"")}  C20  {=IFERROR(INDEX(C$11:C$15,MATCH($B20,$B$11:$B$15,0)),"")}  D20  {=IFERROR(INDEX(D$11:D$15,MATCH($B20,$B$11:$B$15,0)),"")}  E20  {=IFERROR(INDEX(E$11:E$15,MATCH($B20,$B$11:$B$15,0)),"")}  A21  {=IFERROR(INDEX($A$11:$A$15,MATCH($B21,$B$11:$B$15,0)),"")}  B21  {=IFERROR(INDEX($B$11:$B$15,SMALL(IF($B$11:$B$15<>"",ROW($B$11:$B$15)ROW($11:$11)+1),ROWS($11:13))),"")}  C21  {=IFERROR(INDEX(C$11:C$15,MATCH($B21,$B$11:$B$15,0)),"")}  D21  {=IFERROR(INDEX(D$11:D$15,MATCH($B21,$B$11:$B$15,0)),"")}  E21  {=IFERROR(INDEX(E$11:E$15,MATCH($B21,$B$11:$B$15,0)),"")}  A22  {=IFERROR(INDEX($A$11:$A$15,MATCH($B22,$B$11:$B$15,0)),"")}  B22  {=IFERROR(INDEX($B$11:$B$15,SMALL(IF($B$11:$B$15<>"",ROW($B$11:$B$15)ROW($11:$11)+1),ROWS($11:14))),"")}  C22  {=IFERROR(INDEX(C$11:C$15,MATCH($B22,$B$11:$B$15,0)),"")}  D22  {=IFERROR(INDEX(D$11:D$15,MATCH($B22,$B$11:$B$15,0)),"")}  E22  {=IFERROR(INDEX(E$11:E$15,MATCH($B22,$B$11:$B$15,0)),"")}  A23  {=IFERROR(INDEX($A$11:$A$15,MATCH($B23,$B$11:$B$15,0)),"")}  B23  {=IFERROR(INDEX($B$11:$B$15,SMALL(IF($B$11:$B$15<>"",ROW($B$11:$B$15)ROW($11:$11)+1),ROWS($11:15))),"")}  C23  {=IFERROR(INDEX(C$11:C$15,MATCH($B23,$B$11:$B$15,0)),"")}  D23  {=IFERROR(INDEX(D$11:D$15,MATCH($B23,$B$11:$B$15,0)),"")}  E23  {=IFERROR(INDEX(E$11:E$15,MATCH($B23,$B$11:$B$15,0)),"")}  E24  =SUM(E19:E23) 

Like this thread? Share it with others