copying data between sheets

Hi,

Try the following array formula in Sheet2, E3:

{=IFERROR(INDEX(Sheet1!$B$2:$G$6,SMALL(IF(COUNTIF($D3,Sheet1!$B$2:$B$6)*COUNTIF($C3,Sheet1!$G$2:$G$6),ROW(Sheet1!$B$2:$G$6)-MIN(ROW(Sheet1!$B$2:$G$6))+1),COLUMN(A1)),ROW(B$2)),"")}

to be confirmed by pressing CTRL+SHIFT+ENTER