I am trying to use the look-up feature to sort/find data withhin a
spreadsheet. Here is what I am trying to do:

Cell A: Employee Number (all employee's)
Cell B: Hours worked
Cell C: Tips earned
Cell D: Employee Numbers (all employee's from a specific store)
Cell E: Hourly Rate of Pay (ee's fron store above only)

I'm trying to find the Cell B information for each of the Cell D employee's.
So i'm trying to look up the employee number in Cell D, find it in column A
and then give the result that is in cell B. So if the employee number in D3
matches the employee number in A66 then I the result should be B66.

How do I do this?