Hlookup Issue

I'm trying to get back on my sheet the department name for a user id I have in either sheet1's data or sheet 2's data.

But everytime I do a Hlookup it goes N/A when it should display "E&T Aero" as department for the number given in the example.

At the moment it's N/A but if I put in the "TRUE" reference it does the last column of the arrays header.

Any help or a new technique how to get it to lookup appreciated, Thanks