For some reason my MATCH from sheet to sheet is off by 13 and I just can't work out why. See below example and also a snip of the two sheets showing the data it's pulling from 13 days prior to the MATCH date. Any help would be greatly appreciated ?
Cell Formulas | ||
---|---|---|
Range | Formula | |
C2 | C2 | =Sheet1!F1-13 |
D2:V2 | D2 | =C2+1 |
C3 | C3 | =IFERROR(INDEX('[EMPLOYEE ROSTER.xlsx]ROSTER'!$N$5:$AWG$250,MATCH($A3,'[EMPLOYEE ROSTER.xlsx]ROSTER'!$E$5:$E$250,0),MATCH(C$2,'[EMPLOYEE ROSTER.xlsx]ROSTER'!$3:$3,0)),"0") |
C4:V8,D3:V3 | D3 | =IFERROR(INDEX('[EMPLOYEE ROSTER.xlsx]ROSTER'!$N$5:$AWG$250,MATCH($A3,'[EMPLOYEE ROSTER.xlsx]ROSTER'!$E$5:$E$250,0),MATCH(D$2,'[EMPLOYEE ROSTER.xlsx]ROSTER'!$3:$3,0)),"") |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
A1:AR300 | Expression | =A1="AL" | text | NO |
C2:AZ2 | Expression | =C$1="Mon" | text | NO |