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