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
Absence Writeup Sheet:
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