Hi,
I am writing a macro which can find if a cell in Column B contains the words in column A. If it does, it writes result in column C.
eg. in the following table, B3 has word 'not' so 'Found' is displayed in C3.
Goal:
<tbody>
<tbody>
A
B
C
1
Look for
Look into
Result
2
not
Sunday is...