How do I use the LOOKUP feature in Excel

E

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?
 
R

Roger Govier

Hi Elena

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import data from 1 cell on 1 worksheet to othr cell(s) in another 1
Multiple Column Lookup in Excel 2003 3
copying one cell in multiple sheets into a column on one sheet 3
Index and Match 8
2 Q's. How to add X months to a date & 1
Linking two VLOOKUP functions - Excel 2003 2
how do i use > or = to in a formual for excel 3
How do I only make a cell available if an option from a differentvalidated cell is selected in Excel 2

Top