Populating current weeks scores via drop down name box

Hi,

First off, I can not upload my file to show you so any help would be greatly appreciated.

then,

I need to be able to look up a person, and be able to look at any particular weeks performances via the drop down list in C1 (Name) and C19 (Week) on A Shift Profiles tab on the workbook that i have attached.

I currently have most of that working apart from the score for the particular week being dragged over.

In the Cell range C22:M22, on A Shift profiles the formula:-

=INDIRECT("'"&$C$19&"'!"&CELL("address",$C6))

only drags from cell C6 on Productivity Tracker sheet instead of looking up the Name in C1 on A Shift profiles, then looking up on Productivity Tracker and matching with those scores.

any help would be great.

Thanks.

Please attach a dummy file. Go to;

Go Advanced >> Manage Attachments.
Top right side, click Add Files.
Select file browse your file, then click
Upload files.
Then, on the right bottom side click Done.
Submit reply.