OK, then like this:
=MATCH(LEFT(B2,C1)&"*",A:A,0)
this will produce a numeric result for a match of the first x number of characters of the value of B2 match the same first x number of characters of a value in column A - the value of x is in C1 - and it will produce #N/A where no such match is found
Bookmarks