How to use Index Match to return multiple values

[pingpoeng]

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

[Haseeb Avarakkan]

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

Please Login or Register  to view this content.

Then copy down as necessary.

[pingpoeng]

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