Wildcard in Table Range

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?