I have some values in a column A. I want to have a formula next to each value in a column B that would tell me if text from column A is in any of the cells from columns C.
I tried match, search but didn't make it work in OpenOffice Calc
The data looks like
Column A B C
1 yes 0
2 no 1
3 no 4
4 yes