Vlookup or index match possibly needed

[Noah101]

Good evening Programming Experts,

I need your assistance , I have an excel sheet with a dashboard on sheet1 and raw data on sheet 2. I'm trying to use a v lookup or index match but its failing, not sure if its the way my raw data set up but by the looks of it all looks good.

below is my dashboard view

02-Nov Monday
quality Metric NCC-O NCC-A ABB-D ABB-D%
Grand Total



02-Nov Monday
quality Metric NCC-O NCC-A ABB-D ABB-D%
John Doe
Amy Watson
Justin Brown
Noah Anderson

below is my raw data view

Roll UP Monday Tuesday Wednesday Thursday Friday
Met Target 22 21 16 21 22
NCC-O 16 13 21 11 9
NCC-A 23 21 32 33 16
ABB-D 14 17 22 13 22
ABB-D% 5 3 6 7 3


John Doe Monday Tuesday Wednesday Thursday Friday
Met Target 3 5 3 2 1
NCC-O 6 7 8 7 2
NCC-A 3 3 5 7 9
ABB-D 1 1 1 1 1
ABB-D% 5 6 8 9 9

Amy Watson Monday Tuesday Wednesday Thursday Friday
Met Target 3 5 3 2 1
NCC-O 6 7 8 7 2
NCC-A 3 3 5 7 9
ABB-D 1 1 1 1 1
ABB-D% 5 6 8 9 9


Justin Brown Monday Tuesday Wednesday Thursday Friday
Met Target 3 5 3 2 1
NCC-O 6 7 8 7 2
NCC-A 3 3 5 7 9
ABB-D 1 1 1 1 1
ABB-D% 5 6 8 9 9



Noah Anderson Monday Tuesday Wednesday Thursday Friday
Met Target 3 5 3 2 1
NCC-O 6 7 8 7 2
NCC-A 3 3 5 7 9
ABB-D 1 1 1 1 1
ABB-D% 5 6 8 9 9


I would like the raw nicely summarized in the dashboard. The only thing that I would need say is my dashboard DAY OF WEEK is programmed to change each day so it will become Monday then Tuesday then Wednesday ect. I want the formula to capture that in the dashboard from the raw data as the days change,

I have also attached my excel document to make it easier.

Thank you greatly.