This is an odd one. Here is the formula.
=IFNA(IF(VLOOKUP(C255,'Task Data'!$A$4:$AT$3005,39,'Task Data'!$AM$4:$AM$3005)=1,"Non-Compliant","Compliant"),"Compliant")
The issue is when the function looks in 'Task Data' for what C255 is and there are two of them (in two different rows) it appears it only works if 1 is in the top row, i.e. it results and shows "Compliant". If the 1 is in the lower row, it still shows "Compliant" but it should be "Non-Compliant". It appears it is not seeing the second 1 in the second row. Hopefully this makes sense.