You can also use VLOOKUP. As I understood the question, you could use this formula in Sheet1 'U' column:

Put this in sheet1 column U (I assumed data is starting from 2.row, so I put it there and dragged down to 5.row) rearrange formula for your ranges.

=VLOOKUP(B2;Sheet2!$E$2:$S$5;15;FALSE)