Why my find function not work all the time here?

[woshichuanqilz]

Please Login or Register  to view this content.

This is my code I try to find in the F1:F14 which value is in the column B, if find it add "find it" at J column, the result is that only two value in match, but it is obviously that there are more than 2 match value. Why is that ?

[Special-K]

Your data doesnt look right, F5 is HG221-4, that won't find HG221-0/4 (B5), if that's what you're trying to do.

You haven't explained whether you are searching for entire data or partial data search.

Run the code again, it works fine where column B equals column F.
Where you have extra data in the cell, e.g.
HG221-0/4 there is no match against HG221 since only part of the data matches, ie HG221
Same goes for HG231-2 does not match HG231

Are you searching for exact matches or partial?