•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Wildcard in Table Range
Our take
Are you struggling to match alphanumeric values in your spreadsheet when wildcards are involved? This challenge can feel daunting, especially when dealing with tiered numbers where each digit conveys essential information. Fortunately, there’s a way to leverage wildcards within your table range, enhancing your lookup capabilities without getting lost in complex formulas. In this guide, we’ll explore effective strategies to incorporate wildcards into your dataset seamlessly. Keep reading to discover how this approach can transform your data matching process and streamline your workflow.
Hello,
I have a list of alphanumeric values (all 14 digits) in a spreadsheet. I need to bump these up against another spreadsheet using a dataset of alphanumeric values but some are wildcards (some are 10 digits). The wildcards would be a subset of the full 14 digit number (think of it like a tiered number where every digit in place means something).
I have found a lot of sources that talk about wildcards as the lookup value, but not the wildcards being part of the table array. Is there a way to make this work?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience