Hi, I tihnk I had a similar problem, it was answered in a previous post


http://www.excelforum.com/showthread.php?t=362019

It's right down at the bottom of the thread. Basically the asnwer was
to use wildcards in your If statement:

" Try using wildcards...

=COUNTIF(A:A,"*"&B2&"*") "


--
saybut
------------------------------------------------------------------------
saybut's Profile: http://www.excelforum.com/member.php...fo&userid=5949
View this thread: http://www.excelforum.com/showthread...hreadid=484228