Ask Experts Questions for FREE Help !
Ask
    mitank's Avatar
    mitank Posts: 8, Reputation: 1
    New Member
    		  
    #1

    Nov 18, 2008, 10:09 PM
    Excel formula
    I am using Excel 2007.
    I have 2 Sheets.
    In first sheet there are 3 coloumns, first one contains the employes number, second coloumn contains the name of employes and third one contains the department he works in.

    In the second sheet I have drop down list of the names of employes and the employee number.

    Now for Example

    When I select from the drop down list and if I select employee "A", and the employee number as "6506", only if these two criteria matches perfectly with sheet 1, I should get the department he works in. If id does not match the cell should be blank.

    In this in one department there are many employees working, BUT only if the above 2 criteria matches I should get the department he works in, else the cell should show blank.

    Please show with example and if possible downloadable excel sheet.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Nov 19, 2008, 05:07 AM
    Will this work for you?
    Attached Files
  1. File Type: xls Index-Match.xls (14.0 KB, 210 views)
    2. ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
    		  
    #3

    Nov 19, 2008, 05:50 AM

    This doesn't make sense. An Employee number should be unique. No two employees should have the same number. So there should be no reason to use name as well.

    A VLookup formula will pull the department based on the employee number.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #4

    Nov 19, 2008, 08:09 AM

    I was thinking the same thing, but thought I'd give her the answer she asked for first. A straight VLookup will draw all the other pertinent data (Name/Dept/Favorite Color) from the first sheet...
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

About excel formula v-lookup [ 2 Answers ]

Hi! I Need Help... How To Use V-lookup Formula In Excel . Give Me Answer With Example Thanks

Excel Formula [ 1 Answers ]

Hi I have come across another problem with my spreadsheet. I have tried quite a few different ways to do it but can't get any of them to work. Within my spreadsheet I have a quote price and a forcasted date. However when a order is definitely received then a sale price and a new date is put into...

Excel formula IF function [ 2 Answers ]

Hi. I am creaing a spreadsheet for work. Basically I have a column that shows all the project names, it shows a date and a price for the project. I need this price to then be automatically placed into the appropriate monthly column. I.e if the project is 20,000 and happened on the 21st of jan...

Excel formula [ 3 Answers ]

I have a column that you manually enter a number; either 0 (zero) or any number greater than zero. I have another column with the formula of: =DAYS360(AN22,AQ22) If the resulting formula figure/number is greater than the manually entered number then I want a third column to equal: $0.00 But...

Excel Formula needed [ 1 Answers ]

I am keeping an inventory in Excel. Let's say I start with 100 units of widgets, I take 20 widgets from the shelf, but return 10 wdgets later because I didn't use them. I need a formula that shows the 100, then I want to show that I took 20, and then have Excel show that I returned 10. Can...

View more questions Search