How do I use the LOOKUP feature in Excel

[Elena D]

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?

 

[T. Valko]

Try one of these:

=VLOOKUP(D3,A:B,2,0)

=INDEX(B:B,MATCH(D3,A:A,0)

 

[Roger Govier]

Hi Elena

Try
=IF(D3="","",IF(ISERROR(VLOOKUP(D3,A:B,2,0)),"",VLOOKUP(D3,A:B,2,0))