Wild Card?

I'm writing an IF statement and I wonder how to write it as a wildcard? The field I'm checking a value on shows 0002450_001009_5504. The part of the field that I"m worried about is the last 4 digits (5504). If a column contains this and others then I want the value to be blank.

Is it possible by checking the value against another workbook's values?