I have 2 worksheets,
Worksheet1 A3:A20 are names, B1:H1 are days of the week (SUN-SAT),
B2:H2 are days of the week to match the calender days
(2/1/2005-8/1/2005),when you change the sun date it changes the whole
weeks date.
Worksheet2 A2:A366 dates of the year (1/1/2005-31/12/2005), the next
column is based on a 4on/2off works rota system, B2:B366
on/on/on/on/off/off/on/on/on/on/off/off & so on. C1:Z1 have the same
names as sheet1 column A.

I need a formula that looks at a name & date on worksheet1, Looks at
worksheet2 for the same name and date, (J Bloggs (h1) on the 6/1/2005
(A7)) then return the data from the intersection of the grid ref, if
empty return the data from B7.


--
Caveman
------------------------------------------------------------------------
Caveman's Profile: http://www.excelforum.com/member.php...o&userid=27546
View this thread: http://www.excelforum.com/showthread...hreadid=480429