Hi all,

I'm new to excel's advanced features and could really do with some help
on this one.

I have the dates for the coming month. I wish to lookup shift patterns
from another sheet.

Sheet 1 has the dates and a column for the results and column for shift
code (which I plan to hide)

We have a four week rotating shift with shifts labelled as such
M1
T1
W1
T1
F1
S1
S1
M2
T2
W2 etc. right up to S4

Question really is how do I get these shifts to be displayed on the
main sheet.

i.e. If I type in M1, I want that shift to be displayed, or M2 then
that shift. I cannot seem to find a straight answer for this.

I look forwards to hearing from you all, thankyou in advance,

Jamie


--
Jamie Dow
------------------------------------------------------------------------
Jamie Dow's Profile: http://www.excelforum.com/member.php...o&userid=26008
View this thread: http://www.excelforum.com/showthread...hreadid=393668