Is it possible to make lookup where wildcards are in the look up value, not the lookup array values?

I'm trying to identify document types by key words the file name contains. For example, i want all documents with a name that contains the word "apple" to be matched to "apple inventory". Documents might be named "apple stock in April" "January apple count" "current apple inventory". All of these documents are in the list and i need them all to be matched with the same type for an automation that will run through each row in a sheet. Is there a way to do this? There are lots of examples for doing this the other way around, where the lookup value is "apple" and it will search an array for cells containing "apple" with wildcards before and after.