Staff Rotas Name List

[Simont485]

I have 2 workbooks that are used for staff rotas (A & B). In both Rotas the layout is shown as: names in Column A A2:A7 dates in Row 1 A2 :NL2. Shifts are shown as D, E, M or N

In Rota A there is a cell to input a date and the rota scrolls across to that date.

I would like it to then show the names of staff on shift for the same date from Rota B.

 

[onlyadrafter]

Hello,

there are probably many ways to do this. Also depends on how you want the results to be shown.

So, I have the two workbooks, laid out the same as per your post.

In Rota A, cell A10 I have a date, in cell B10 i have this formula:

=IF(ISBLANK(INDEX('[Rota B.xls]Sheet1'!$A$1:$N$7,ROW()-8,MATCH($A$10,'[Rota B.xls]Sheet1'!$1:$1,0))),"",'[Rota B.xls]Sheet1'!$A2)

copy down to B15.

You will need to change sheet names (and possible filenames) to suit.

Is this of any use?