Hello,
I was hoping someone could assist with this one. In the attached workbook I have example of raw data from columns A:P. In the table starting from column T is where my results will be. I need a formula that matches the names in column T with column A, also matching the numbers in row 1 (starting in U1) with the name of the person for that row in column T, while also looking up column P for that person to see if they have any of the Monday to Friday days associated to them in column P. If they do i'd like to put the word yes in the corresponding cell in the second table that relates to the name, number and day of week.
Each column of the raw data on the left has around 600 - 800 rows. Also the results table on the right has some names in column T that don't appear in the raw data but still need to be showcased.
I'm open to different formats if there's a better way. But I need to work out something that gives me a similar layout to the table on the right and tells me what day each person has completed each number across the top.
Thanks!
Bookmarks