Comparing with wildcard values

[Zargon_osu]

I need a logical test between a cell and a sting that includes wildcard
values. For instance:

return 1 when comparing AA10-14 to AA*10* where the stars are
wildcard for any number of any characters
but 0 when comparing AA11-13 to AA*10*, etc

Is there a function that does this? Most functions like EXACT and just
logial "=" dont accept wildcard values.

Thanks

 

[J.E. McGimpsey]

one way:

=1-ISERR(SEARCH("AA*10*",D1))