•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Is it possible to make lookup where wildcards are in the look up value, not the lookup array values?
Our take
In this query, the user seeks a method to perform lookups where wildcards are applied to the lookup values rather than the lookup array. Specifically, they want to categorize documents based on keywords in their filenames, such as "apple." The goal is to match various filenames containing "apple" to a single category, "apple inventory." While many examples exist for traditional lookups, the challenge lies in adapting this concept to allow wildcards in the lookup value itself. Is there a viable approach to achieve this?
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.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#financial modeling with spreadsheets#rows.com#Excel compatibility#row zero#automation in spreadsheet workflows#generative AI automation#workflow automation#Excel alternatives#cognitive automation#apple#lookup#wildcards#matched#document types#key words#inventory#file name