Hi there,
I'm looking for some help with the attached rota.
Basically, what i'm looking for is help with a formula to populate a rota and make things a bit easier to manage.
Say for example on the 'Rota' sheet, if I was looking at B9, I would like to work out how i could get the spreadsheet to look on the 'Hours' spreadsheet for the a 2-10.30 shift in the B column of that sheet, and then when it finds 2-10.30, it shows the persons name from the A column on the 'Rota' Sheet.
So for example on the document I attached, on the hours sheet, it would look down the whole B column, find 2-10.30 in B11, and then would display the value of A11, in this case 'Bill'.
Does that make sense? I'm fairly new to excel, i'm been trying things like VLOOKUP and MATCH but can't seem to get anything to work.
Any help would be most appreciated, although i'm not even sure if what i'm asking is possible!
Thanks
Bookmarks