MATCH not being recognized

[chrono2483]

Hello,

I'm trying to match the ID found in Col A, with a list of IDs on Sheet 4. They were pasted from different sources. I've tried to format paint to match, however it doesn't seem to recognize the IDs even though they are a match. I know the formula works because when i copy/paste the ID from Sheet 4 into Col A, the formula returns "YES"

The formula is: =IF(ISNUMBER(MATCH($A2,Sheet4!$H:$H,0)),"YES","NO")

Am i missing something, in order to get this to work, without having to copy/paste every single ID?

Thank you!

 

[Aladin Akyurek]

Does one of the following suit better to the input?

=IF(ISNUMBER(MATCH($A2,Sheet4!$H:$H,0))+ISNUMBER(MATCH($A2&"",Sheet4!$H:$H,0)),"YES","NO")

=IF(ISNUMBER(LOOKUP(9.99999999999999E+307,SEARCH($A2,Sheet4!H:H))),"YES","NO")