You could use a different vlookup in each of the columns, see below.
C2: =IF(VLOOKUP(Sheet1!$A2,Sheet2!$A:$I,3,FALSE)="","",VLOOKUP(Sheet1!$A2,Sheet2!$A:$I,3,FALSE))
D2: =IF(VLOOKUP(Sheet1!$A2,Sheet2!$A:$I,4,FALSE)="","",VLOOKUP(Sheet1!$A2,Sheet2!$A:$I,4,FALSE))
E2: =IF(VLOOKUP(Sheet1!$A2,Sheet2!$A:$I,5,FALSE)="","",VLOOKUP(Sheet1!$A2,Sheet2!$A:$I,5,FALSE))
F2: =IF(VLOOKUP(Sheet1!$A2,Sheet2!$A:$I,6,FALSE)="","",VLOOKUP(Sheet1!$A2,Sheet2!$A:$I,6,FALSE))
G2: =IF(VLOOKUP(Sheet1!$A2,Sheet2!$A:$I,7,FALSE)="","",VLOOKUP(Sheet1!$A2,Sheet2!$A:$I,7,FALSE))
H2: =IF(VLOOKUP(Sheet1!$A2,Sheet2!$A:$I,8,FALSE)="","",VLOOKUP(Sheet1!$A2,Sheet2!$A:$I,8,FALSE))
I2: =IF(VLOOKUP(Sheet1!$A2,Sheet2!$A:$I,9,FALSE)="","",VLOOKUP(Sheet1!$A2,Sheet2!$A:$I,9,FALSE))