Application.Match help. Find a match if first 4 numbers are the same. Asterisk not working

In my project, I am searching through a column that would have data as follows:
B692.920
A254.R30
GN99.900
AN49.TST
etc. etc.

I want to match the values with a column from another worksheet that would have the following:
B692
A254
GN99

If a match is not made, the row is to be hidden on the original sheet.
The code works fine when i put the complete number in the column in the other sheet, however, I want to be able to match based upon just the first four.

I have attached my code snippets below. The line highlighted in red is my issue. I have tried

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

Both to no avail, hiding all of my rows.

Please Login or Register  to view this content.

Any ideas?!

Match function works with EXCACT match only.

Originally Posted by AB33

Match function works with EXCACT match only.

On the MS website it has three variations of MATCH using 1, -1 and 0. It also says you can use "*" to match any sequence of characters and "?" to find any single character

Originally Posted by JBeaucaire

Normally, I would insert a formula in an empty column on the DM sheet to evaluate all the rows all at once, then hide the unwanted rows with an Autofilter, this would not loop at all.

But for your project, my first suggestion is instead of trying to Match, use the FIND method.

Please Login or Register  to view this content.

I am going to try your method. However your suggested method before it I do not think is plausible in my application. My macro first opens a file, then searches the file for specific constraints in certain columns and copies those rows onto appropriately labled tabs, "DM" being one of them, then it does a sort by a few different constraints, and then it implements the snippet i posted.

don't have time to code it, but if you use a trim function on the data you want to compare (only look at the first four characters) you should be able to find matches and hide if there not matching pretty easily.

Originally Posted by blackspiral

don't have time to code it, but if you use a trim function on the data you want to compare (only look at the first four characters) you should be able to find matches and hide if there not matching pretty easily.

This could work, however, I forgot to specify the user CAN enter the full number if they want(B692.920) or just the first 4. The numbers stand for project numbers, and sometimes we want to see specifics of a certain project or just the whole project.

ok, so count the number of characters not including the "*" in the input. Then trim the values you search for matches with that many characters.

I ended up just going a different route. It is actually a lot easier and works better for my application. Thank you all for your help. Here is my code I am now using:

Please Login or Register  to view this content.