You can try this formula,

=HLOOKUP(Sheet1!A38;Sheet2!A1:E38;38;FALSE)
but if the value from Sheet1!A38 is not found in Sheet2!A1:E38 range, this formula will show #N/A error. There is another method, but you have to tell first if this is what you need.