My problem is I work in a muanfacturing plant where we reference shifts in 2
different formats Nights,Earlys & Lates or A,B & C Shift.

I have set up a speadsheet in excel where I download data weekly from
another program for Weekly Scrap, OEE & Downtime Data.

My problem is in the columns reading from the left I have Date & Shift and I
want to use both to lookup against. For example 02.09.08 & Early in the data
set on a seperate sheet I would a Date File in order showing on a particular
Date & Shift it would be C - 02.09.08 Early C.

Pleae help as we work a rotating 3 Shift pattern so If I could link the
shift A,B or C to the database would be a massive help

Thanks
Regards
Jonesy