Once at D59 =IF('Pilot List'!$G$28>=1,IFNA(INDEX($A$4:$C$51,MATCH(0,COUNTIF($D$58:$D58,$B$4:$B$51)+($C$4:$C$51<>$E$57),0),COLUMN(B4)),"Empty"),"") and then again D86 =IF('Pilot List'!$J$28>=1,IFNA(INDEX($A$4:$C$51,MATCH(0,COUNTIF($D$85:$D85,$B$4:$B$51)+($C$4:$C$51<>$E$84),0),COLUMN(B4)),"Empty"),"")

They are suppose to do the same thing, just use a different Cell to get the reference

The first one is working, but the second is doing weird things

It is a big book, bouncing across a few different sheets - so here is a link to download it - https://www.dropbox.com/s/l4biughyyaopfjv/WCMRC-BuzzCup.xlsm?dl=0

The aim is to look up the name, and if there is a number that isnt dividable by 4, to type "Empty"

The first set is working perfectly

The second one is adding a 0 instead

Any help would be useful

Thanks