MATCH FUNCTION Issue: Tracking Attendance for a Rolling Year

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:

Please Login or Register  to view this content.

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:

Please Login or Register  to view this content.

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

Whiskey Attendance Match Help.xlsx

I must say you have very well maintained data..

Now since you are doing look up on either first name or last name what we can do is unmerge cell A4, then merge only cell B4 to E4 & keep validation as it is...

Remove validation from Cell A4 & put formula =LEFT(B4,-1+FIND(" ",B4))

Now change Text color to white & you can hide & lock the cell..

Now you can see you can change first & last name & nothing else is changed...

See attachment i have changed it for you..

Thanks!

SRWilson87,

In the fie you uploaded, replace B8 with the following:

Please Login or Register  to view this content.

I've colored the part that changed. What it does is, since the first name works, it extracts the first name from the full name when you choose one from data validation...

PS: The downside occurs when/if two have the same first name.

PPS: Essentially does same as excelliot's solution without changing A4

Ok, so how exactly should I rework that on the Getting Data page?

Please Login or Register  to view this content.

This is what i put in for cell J6 in the Getting Data tab.. looked to be right.. but it doesnt track something right.

Alright, so I thank the both of you for all the assistance you've provided to me. I have a working copy I'll upload, and let you take a look and see if you can find any issues that I may have missed.


Working Perfectly.xlsx

And Jhren, you've done me a great service by noticing the issue with my original coding, in that it would incorrectly recognize the data from a like named individual.

Again, thanks to the both of you.