i have two columns. If a word or words in the world list is found in the text string in column A, I want to put found in the adjacent cell or not found. I want to be able to drag cursor down column C.
<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
A | B | C | |
---|---|---|---|
1 | Statement | Word List | |
2 | Dog jumped over the moon. | Jumped | |
3 | It is a good day. | Good | |
4 | 200 Mountain Street | street | |
5 | I am glad it's Friday. | am glad | |
6 | I love pizza. | I love | |
7 | Dell laptop | Sonya | |
8 | |||
9 | Results | ||
10 | Dog jumped over the moon. | found | |
11 | It is a good day. | found | |
12 | 200 Mountain Street | found | |
13 | I am glad it's Friday. | found | |
14 | I love pizza. | found | |
15 | Dell laptop | Not found |
<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1