Suppose in Col A you have the data..and
B1 enter a text mathcing with one of the entries in Col A

The below formula in C1 will check for the first 5 characters of B1 in ColA
and return "No match" if a match is not found. If a match is found formula
will return blank

=IF(ISERROR(MATCH(LEFT(B1,5) & "*",A:A,0)),"No Match","")
--
If this post helps click Yes
---------------
Jacob Skaria


"my_melody" wrote:

Can I match texts in 2 columns (one column has a longer string than the other
column so let's say it should be able to match the first 5 characters) and
then highlight the ones that have no matches...