fareedexcel
Member
The final data to appear as per the Drop down list (Manager Name). Need your help.
Drop Down List Filter
- Thread starter fareedexcel
- Start date
Try,
1] B5 =IFERROR(INDEX(Sheet1!$C$3:$C$8,AGGREGATE(15,6,ROW($A$1:$A$6)/(Sheet1!$E$3:$E$8=$H$3)/(Sheet1!$D$3:$D$8=B$4),ROW($A1))),"")
copied right to E6, and all copied down.
2] B12 =IFERROR(INDEX(Sheet1!$C$3:$C$8,AGGREGATE(15,6,ROW($A$1:$A$6)/(Sheet1!$E$3:$E$8=$H$3)/(Sheet1!$D$3:$D$8=B$11),ROW($A1))),"")
copied right to E12, and all copied down.
1] B5 =IFERROR(INDEX(Sheet1!$C$3:$C$8,AGGREGATE(15,6,ROW($A$1:$A$6)/(Sheet1!$E$3:$E$8=$H$3)/(Sheet1!$D$3:$D$8=B$4),ROW($A1))),"")
copied right to E6, and all copied down.
2] B12 =IFERROR(INDEX(Sheet1!$C$3:$C$8,AGGREGATE(15,6,ROW($A$1:$A$6)/(Sheet1!$E$3:$E$8=$H$3)/(Sheet1!$D$3:$D$8=B$11),ROW($A1))),"")
copied right to E12, and all copied down.
fareedexcel
Member
Thanks @bosco_yip for your support. Formula is working fine.