Pl see file wth formulas.
For B5
For C5![]()
=IFERROR(INDEX(Sheet1!$C$2:$C$28,SMALL(IF((Sheet1!$A$2:$A$28=Sheet2!$C$2)*(Sheet1!$B$2:$B$28=Sheet2!$D$2)*(Sheet1!$L$2:$L$28=Sheet2!C5),ROW($A$2:$A$28),""),COUNTIF($C3:$C5,C5))-ROW($A$2)+1),"")
then drag down.![]()
=IFERROR(LARGE(IF((Sheet1!$A$2:$A$28=Sheet2!$C$2)*(Sheet1!$B$2:$B$28=Sheet2!$D$2),Sheet1!$L$2:$L$28,""),ROW(A1)),"")
Bookmarks