I have the following index formula in my sheet twice
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
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