Copied Array Formula across Sheet, activated, but Not working. Why?

[Susanna123]

Hi All,

I have come across another issue while practicing with a Leave Tracker (without Macros).

I have a calendar across a sheet (January to December) and I have inserted an Array Formula in 1-Jan-22 to show when a Holiday has been taken (according to the Leave Records in another sheet).
The problem is that the calendar does not show any leave.

{=IFERROR(INDEX(Records!$D$2:$D$150,MATCH(1,IF(C$6>=Records!$E$2:$E$150,IF(C$6<=Records!$F$2:$F$150,IF($B7=Records!$B$2:$B$150,1))),0)),"")}

The Array formula is Active "{}" through out the calendar but maybe I made a mistake when copying the array formula as the cell $B7 remains the same in all cells formulas instead of the second reference changing into $B8,$B9,$B10 etc..

I am not sure if that is the reason why nothing is showing. If it is, how does one copy an Array Formula step by step?

Here's a link to the Document: CLICK HERE

I apologise in advance if my problems are silly but thanks.

 

[Fluff]

You need to delete the formula from all those cells, then re-enter it in C7 confirm it with Ctrl Shift Enter & then drag down & across