Your If statement is looking for "004", etc. I would think that the zeros don't exist, they are put there by Formatting so nothing would be found.

The Select case is much neater