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
Bookmarks