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.
Bookmarks