Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

There is an ODS file.
In this ODS file I need to search in C2:C216.
And there is the C2:C216 cells where I write stuff (yes, the same place where I need to search..).
There is the E2 cell where I need the "function" to say yes or no

My question: How does the the function looks like that with I can search for things* I write in C2:C216? If there is a match in C2:C216 then the function in E2 should say yes. Otherwise no.

*in C2:C216

share|improve this question
I can't understand your question. To make the question clearer, please try to give an example of what you are trying to do, with a small number of cells (3 or 4). What sort of "search" are you trying to execute? For a specific string? Or a pattern? –  allquixotic Dec 13 '13 at 15:28

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.