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?

Try one of these:

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

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

--
Biff
Microsoft Excel MVP


"Elena D" wrote in message
...
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?

Hi Elena

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

--

Regards
Roger Govier

"Elena D" wrote in message
...
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?