Hi,

Am Wed, 3 Sep 2014 16:51:56 +0100 schrieb SVRider:

A B c
1 4213211_ghdjk_null_2_ 4213212 True
2 4213212_ghdjk_null_7_ 4213211 True

=COUNTIF($A$1:$A$100,B1&"*") will give you the number of matches
=IF(COUNTIF($A$1:$A$100,B1&"*")0,"True","") will give you True if the
number matches


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional