Try using the "FIND" function. It allows you to find text within a cell
with text.

If the text is not found it returns a #Value.

Then use the "ISERR" function to determine if you have a match.

You may need to use more than one column to get the result you want.

Hope this helps.

Frank


--
fcastrofilippo
------------------------------------------------------------------------
fcastrofilippo's Profile: http://www.excelforum.com/member.php...o&userid=36542
View this thread: http://www.excelforum.com/showthread...hreadid=563236