I would like to compare cells in column B with cells in column A. If
cell in column B is found in column A, corresponding cell in column C
will display message, else "Not Found!".

My problem lies in the fact that text in column B is not exactly equal
to text in column A.

I have read other threads on this but none tackle the text strings not
being exactly equal.

Example;
Cell A1: QWERT ASDF
Cell B1: QWERTYU ASDFG

Any help really appreciated


--
PLPE
------------------------------------------------------------------------
PLPE's Profile: http://www.excelforum.com/member.php...o&userid=23856
View this thread: http://www.excelforum.com/showthread...hreadid=375010