Hi Max,

First of all, thank you for your time to reply.
After several attempts to workaround to understand your formula that
placed in Sheet1 and it seems that the result for E1 to E5 still show
"No match".
Actually, I need the result to be in value that retrieve from column A
in Sheet2.

Rdgs
Len