Index and match formula changing range

Hi i need help when i change the index range my formula gives a #ref error could someone please have a look and see where im going wrong please the K9 cell is the working formula but K10 doesnt work i need to change the range when i use the formula for real

The true range i need it to use is absense ot row 15 - 50

Thanks in advance