"Peo Sjoblom" wrote...
You would need to put the LEFT function on the range where the
lookup/match is made

=MATCH(A3,LEFT(D3:D6,4),0)
....

If A3 had exactly 4 characters, when would this return something
different than

=MATCH(A3&"*",D3:D6,0)

?

More robust, why not use

=MATCH(LEFT(TRIM(A3),4)&"*",D3:D6,0)

?

These will all return the first match, whether or not that's the match
sought.