Originally Posted by joeu2004[_2_]

"KeriM" wrote:
They do work on their own (The range is from my actual data):
[....]
=Match(A3&"*",'[Data]Sheet1'!$B$1:$B$65536,0)
=Match("*"&RIGHT($A$4,3)&"*",'[Data]Sheet1'!$C$1:$C$65536,0)

Try the following array-entered formula (press ctrl+shift+Enter instead of
just Enter):

=MATCH(1,(LEFT('[Data]Sheet1'!$B$1:$B$65536,LEN(A3))=A3)
*(SEARCH(RIGHT($A$4,3),'[Data]Sheet1'!$C$1:$C$65536)<0),0)

"*" works as a wildcard character only in the first parameter of MATCH, not
as part of an IF conditional expression.

(But do you really expect to have up to 65K rows of data?! Rhetorical
question.)


"KeriM" wrote:
If you look at my attached sheets
[....]
I can't upload to a file sharing site since I'm at work
and they are blocked and probably frowned upon.

For future reference....

I cannot see any "attached sheets" in my news reader.

If you can post to a newsgroup and add attachments to postings (which is
uploading, after all), there's a good chance that you can access one of the
listed file-sharing websites and upload a file.

Whatever you included as "attached sheets" (presumably an Excel file) could
be uploaded as a file to a file-sharing website.

You should be able to create a simple example Excel that demonstrates the
problem, but that has no private information. I suspect that is exactly
what you did for the included "attached sheets".