If this then that....

Hi, hope someone can help us with this.

I have two spreadsheets with data and I want to pull info from one to the other. Basically:

If this persons employee number shows on sheet 1, check sheet 2 for the same employee number, and display info from the next cell on sheet 2 on sheet 1.

Hope that's clearer than it reads back.....!