+ Reply to Thread
Results 1 to 3 of 3

How to use Index Match to return multiple values

  1. #1
    Registered User
    Join Date
    04-09-2012
    Location
    Charlotte, North Carolina
    MS-Off Ver
    Excel 2007
    Posts
    2

    How to use Index Match to return multiple values

    Hello everyone!

    I need help and I know this is the right place. I am trying to create an all-in-one excel file for my company. This specific file is regarding Absences and I am trying to create an automatic fill in spread sheet for Absence Write-ups.

    Here is the basic layout:

    Absence Data Sheet:

    ID# 1000 1001 1002 1003
    Name John Smith Jane Smith John Doe Jane Doe
    3/30/2012 1 1
    3/31/2012 1 1 1
    4/1/2012 1
    4/2/2012 1
    4/3/2012 1
    4/4/2012 1
    4/5/2012 1
    4/6/2012
    4/7/2012
    4/8/2012
    4/9/2012 1


    Absence Writeup Sheet:


    <Insert ID#>

    Dates: Blank Blank Blank


    What I am trying to accomplish is only having to enter in the ID# of the employee and have excel find the values in the ID# column and return the corresponding dates.

    I know vlookup will not work and as far as I know "Index, Match" is the way to go but I am stuck.

    Also, I have my whole excel sheet setup based on the =Today() formula. In other words, I have absences setup so that points get knocked off when past six months. I was wondering if there is a way to incorporate that with this formula since the "points" don't get deleted, they just do not count against the employee during the write up.

    I apologize if this is confusing. Please let me know how I can make this clearer as this is my first post.

    Below is an excel file I hope helps.

    Thank you in advanced

    Forum Question.xlsx

  2. #2
    Forum Guru
    Join Date
    05-24-2011
    Location
    Kuwait
    MS-Off Ver
    Office 365
    Posts
    2,200

    Re: How to use Index Match to return multiple values

    In D11 with CTRL+SHIFT+ENTER, rather than just ENTER.

    Please Login or Register  to view this content.
    Then copy down as necessary.
    Regards,
    Haseeb Avarakkan

    __________________________________
    "Feedback is the breakfast of champions"

  3. #3
    Registered User
    Join Date
    04-09-2012
    Location
    Charlotte, North Carolina
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: How to use Index Match to return multiple values

    Thank you so much! This works like a charm. I really appreciate it!

+ 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