Index formula is not working the same in 2 different locations on the same sheet

[BestiaFPV]

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

 

[AliGW]

Yes, I know how the formula works. What I am asking is why do you believe that, on this particular cell, it should resolve to #N/A? It finds row 13 column 2 and returns what is there, which is a zero. The point I am trying to make is that the formula is not working as you expect it to because it is finding a match. What I need to know is why you think it shouldn't.

 

[BestiaFPV]

I`m not sure, I messed around with the first set until it worked with A
Then I was just assuming it should work the same with B


Just messed around with the "Working" Formula, as soon as I change the Reference from A to B ... the same thing happens, so I guess I need to work out how make it work with the reference of B, I need to work out how to filter out the A class

 

[AliGW]

Just found out why it's doing it (C16) - needs changing to 0:

Excel 2016 (Windows) 32 bit

	A	B	C
16	13	0	b

<tbody>
</tbody>

Mess Sheet
​

 

[BestiaFPV]

I am an ID10T
You are a legend .... Thank you very Much

 

[AliGW]

I'm sorry I didn't spot it sooner, but you're welcome!

By the way, been there, done that!!!