Extract data from one range to another

[ionelz]

I need a Formula at B6 (or J6)
I want to extract data from B3:H4 to B5:H6

[azumi]

For Example 1, put this B6 and ENTERED as Array Formula, then copied cross:

=IFERROR(INDEX($B$3:$H$3,MATCH(0,--(COUNTIF($A$6:A6,$B$3:$H$3)=$B$4:$H$4),0)),"")

and this on B7 and ENTERED as array formula also and copied cross:

=IFERROR(IFERROR(INDEX($B$4:$H$4,MATCH(0,--(COUNTIF($A$6:A6,$B$3:$H$3)=$B$4:$H$4),0)),"")/IFERROR(INDEX($B$4:$H$4,MATCH(0,--(COUNTIF($A$6:A6,$B$3:$H$3)=$B$4:$H$4),0)),""),"")

For Example 2, put this on J6 and ENTERED as array formula then copied cross:

=IFERROR(INDEX($J$3:$P$3,MATCH(0,--(COUNTIF($I$6:I6,$J$3:$P$3)=$J$4:$P$4),0)),"")

and this on J7, and ENTERED as array formulas and copied cross:

=IFERROR(IFERROR(INDEX($J$4:$P$4,MATCH(0,--(COUNTIF($I$6:I6,$J$3:$P$3)=$J$4:$P$4),0)),"")/IFERROR(INDEX($J$4:$P$4,MATCH(0,--(COUNTIF($I$6:I6,$J$3:$P$3)=$J$4:$P$4),0)),""),"")

[ionelz]

Thank you so much, works