In C5: =INDEX(Sheet2!$B$2:$B$9,MATCH(Sheet1!E4,Sheet2!$C$2:$C$9,0))
In C6: =VLOOKUP(E4,Sheet2!$C$2:$H$9,1,FALSE)
In C7: =VLOOKUP(E4,Sheet2!$C$2:$H$9,2,0)
In C8: =VLOOKUP(E4,Sheet2!$C$2:$H$9,3,0)
In C9: =VLOOKUP(E4,Sheet2!$C$2:$H$9,4,0) & "," &VLOOKUP(Sheet1!E4,Sheet2!$C$2:$H$9,5,0)