+ Reply to Thread
Results 1 to 4 of 4

Matching multiple cells to different tabs on a worksheet

  1. #1
    Registered User
    Join Date
    10-15-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    94

    Matching multiple cells to different tabs on a worksheet

    Every month I receive data of different employees and where they work. This list will not be the same and will change monthly. I would like to have the first tab on my worksheet be the raw data and then match the employee by the division they work. So there may be 6 employees working "west" division. I want to make a formula that will take all the "west" division employees and autopopulate onto the "west" tab with all the employees information.

    I made an example of what I need. I would like the division to be filtered and all the employee info next to the division automatically with a formula. I was thinking possibly an index and match but I'm not sure how to go about it. Right now I copy and paste multiple divisions. I'm hoping this is possible to do.

    Thanks for your help.

    Index of Employees.xlsx
    Last edited by nickmessick1; 12-17-2012 at 05:40 PM.

  2. #2
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Re: Matching multiple cells to different tabs on a worksheet

    By adding a helper column, would the attached VLOOKUP solution work?
    Attached Files Attached Files
    Please click the * icon below if I have helped.

  3. #3
    Registered User
    Join Date
    10-15-2012
    Location
    Los Angeles, CA
    MS-Off Ver
    Excel 2010
    Posts
    94

    Re: Matching multiple cells to different tabs on a worksheet

    I never thought of doing it like that. It's called normalization right? This is a good fix. Thanks for your help.

  4. #4
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Re: Matching multiple cells to different tabs on a worksheet

    I am not sure what it is called. Ha ha..
    I just know that if you can create a unique ID for each entry, you'll be set when it comes to using vlookups, and automatically distributing your data.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1