Something Simple that I'm missing

[notanexpertinexcel]

Trying to find if CustNumber exists in FinalNumber column.

CustNumber Column has 150k rows, FinalNumber column has 350k rows.

I have tried Match, Countif, Index, etc. There is clearly a match on the value of A2 (which is 0). It shows up like 8 or 9 times in FinalNumber Column.

Do i have some formatting or something turned on? Excel 2013. I'm losing my mind here.

I want it to say EXISTS or DOES NOT EXIST


[TABLE="width: 606"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]CustNumber[/TD]
[TD]Does Column A exist in Column C?[/TD]
[TD]FinalNumber[/TD]
[/TR]
[TR]
[TD="align: right"]0 [/TD]
[TD]No Match[/TD]
[TD="align: right"]80050[/TD]
[/TR]
[TR]
[TD]funny[/TD]
[TD]Match[/TD]
[TD]-----------------[/TD]
[/TR]
[TR]
[TD]IM26043850[/TD]
[TD]Match[/TD]
[TD]!UGCA_1000[/TD]
[/TR]
[TR]
[TD]00001[/TD]
[TD]Match[/TD]
[TD]!UGCA_1000[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Match[/TD]
[TD]!UGCA_1000[/TD]
[/TR]
[TR]
[TD]000002[/TD]
[TD]Match[/TD]
[TD]!UGCA_621.2996.2[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]Match[/TD]
[TD]!WDPH_50[/TD]
[/TR]
[TR]
[TD]55[/TD]
[TD]Match[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]000503516[/TD]
[TD]Match[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]001006848[/TD]
[TD]Match[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]7238194[/TD]
[TD]Match[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]9007910[/TD]
[TD]Match[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]9515722[/TD]
[TD]Match[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]10117837[/TD]
[TD]Match[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]011123056[/TD]
[TD]Match[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]11563884[/TD]
[TD]Match[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]12023067[/TD]
[TD]Match[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]12313758[/TD]
[TD]Match[/TD]
[TD="align: right"]12638129[/TD]
[/TR]
[TR]
[TD]12435664[/TD]
[TD]Match[/TD]
[TD="align: right"]15784153[/TD]
[/TR]
</tbody>[/TABLE]

 

[notanexpertinexcel]

=IF(ISERROR(MATCH(A3,$C$2:$C$400001,0)),"Match","No Match")

 

[snjpverma]

Try this

=IF(COUNTIF(C:C,A1),"Exists","Does not Exist")

 

[notanexpertinexcel]

1st row says Exists, the rest are also all Exists. Is something wrong with my auto fill?

 

[snjpverma]

1st row says Exists, the rest are also all Exists. Is something wrong with my auto fill?

set the calculation mode to automatic instead of manual im formulas tab