Explanation

Excel supports thewildcardcharacters “*” and “?

“, and these wildcards can be used to perform partial (substring) matches in various lookup formulas.

With the numbers converted to text, the MATCH function can find a partial match as usual.

Excel formula: INDEX and MATCH case-sensitive

MATCH supports approximate and exact matching, andwildcards(* ?)

in a text string with the number format of your choice.

Excel formula: Position of first partial match

Excel formula: Partial match with VLOOKUP

Excel MATCH function

Excel TEXT function