If you have more columns, you can try this formulas
In to cell B3 and copy down (If you want
quickly copying formula down, double click mouse to Fill handle)
Code:
=IFERROR(VLOOKUP($A3;INDIRECT("Sheet2!"&SUBSTITUTE(ADDRESS(2;COLUMN(A1);1);"0";"")&":$H$8544");MATCH(B$1;Sheet2!$A$1:$F$1;0);0);"")
In to cell C3 copy to right and copy all down
Code:
=IFERROR(VLOOKUP($A3;INDIRECT("Sheet2!"&SUBSTITUTE(ADDRESS(2;COLUMN(B1)+COLUMN(A1);1);"0";"")&":$H$8544");MATCH(C$1;INDIRECT("Sheet2!"&SUBSTITUTE(ADDRESS(1;COLUMN(A1)+COLUMN(B1);1);"0";"")&":$H$1");0);0);"")
Please see attach