MATCH FUNCTION Issue: Tracking Attendance for a Rolling Year

srwilson87

New Member
Joined
Apr 24, 2015
Messages
5
To start out, this page and its function as a whole, works. My issue, is on the 'Indiv. List' Tab, cell $A$4. I would like for this cell to show the Full Name of the employee, vs either First or Last name.

On the 'Getting Data' Tab, I use this coding, to pull data from each corresponding month:
In my original coding for each cell that is looking through each monthly tab is this:

Rich (BB code):
=IFERROR(IF(INDEX(INDIRECT("'"&TEXT(J$5,"YYYY MMM")&"'!J1:AN100"),MATCH($B6,INDIRECT("'"&TEXT(J$5,"YYYY MMM")&"'!B:B"),0),DAY(J$5))=0,"",INDEX(INDIRECT("'"&TEXT(J$5,"YYYY MMM")&"'!J1:AN100"),MATCH($B6,INDIRECT("'"&TEXT(J$5,"YYYY MMM")&"'!B:B"),0),DAY(J$5))),"")
This tracks the First Name Cell ($B6), and =MATCH for the array across each individual monthly tab, in regards to the date at the top of the column.

If you change it to this:

Rich (BB code):
=IFERROR(IF(INDEX(INDIRECT("'"&TEXT(J$5,"YYYY MMM")&"'!J1:AN100"),MATCH($A6,INDIRECT("'"&TEXT(J$5,"YYYY MMM")&"'!A:A"),0),DAY(J$5))=0,"",INDEX(INDIRECT("'"&TEXT(J$5,"YYYY MMM")&"'!J1:AN100"),MATCH($A6,INDIRECT("'"&TEXT(J$5,"YYYY MMM")&"'!A:A"),0),DAY(J$5))),"")
It will track the Last Name Cell ($A6).

The coding for the 'Indiv. List' tab functions from the same code, the only difference being that I can sort out the blanks, and present as a printable page.
Each cell in the column under "CODE" uses the above coding for the lookup, to find the actual infractions, in regards to the dates.

I need to do this without having to edit or modify any page other than this new 'Indiv. List' and the Data Validation page, which comes with updates as well.

Any help in this matter would be greatly appreciated. But I do believe my issue lies where I'm using Match, vs maybe another formula? Due to its ability to only reference a single cell for lookup?

Thanks again,
SRWILSON87

Current file: http://s000.tinyupload.com/?file_id=03536260579309301429
 
Last edited:

srwilson87

New Member
Joined
Apr 24, 2015
Messages
5
This has been solved. Thanks to anyone who may have taken a glance at what I was working with. If you're interested, I'd be more than happy to post a working file.
 

Forum statistics

Threads
1,082,569
Messages
5,366,360
Members
400,886
Latest member
Fchel

Some videos you may like

This Week's Hot Topics

Top