Web Applications Stack Exchange is a question and answer site for power users of web applications. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I want to check if the value of a cell exists in a range of cells. How can I do this?

Just like you would be able to do "if value in list_of_values" in Python for example.

share|improve this question
Were you able to apply my solutions? – Jacob Jan Tuinstra Jun 6 '13 at 11:55

Please try say:


if you want to find the number 6 in ColumnG:G and/or


if you want to find d in the first seven rows of the first two columns.

By find I really mean count the number of instances in the chosen range.

share|improve this answer

You could try MATCH:

A1     = [Value you are trying to find]
B1:B10 = [Range you are searching in]

=IF(ISERROR(MATCH(A1;B1:B10;0));"Not found";"Found")

You can replace the A1 with formulas that return a value to search for. The 0 ensures actual search, not presupposing an ordered search range.

Ref: Documentation for MATCH

share|improve this answer

Use can do that in different ways:

=IFERROR(IF(UNIQUE(FILTER(B2:B,B2:B="text"))="text";"Found";"Not Found");"Not Found")

=IFERROR(IF(COUNTIF(ARRAYFORMULA(range="text"),TRUE)>0;"Found";"Not Found");"Not Found")

=IFERROR(IF(COUNTIF(ARRAYFORMULA(FIND("text", FILTER(range,range<>""))),">"&0)>0;"Found";"Not Found");"Not Found")

share|improve this answer

Use GoogleSpreadsheet and there


and then connect document via API.

share|improve this answer
Can anyone explain why this is "-3" ? – meeDamian Mar 12 '14 at 16:34
@chester1000 I guess because it does not answer this question and, perhaps worse, might sometimes give the right result just by chance. Also for this Q "and then connect document via API" seems irrelevant to me. – pnuts Jun 17 '14 at 9:59

Your Answer


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

Not the answer you're looking for? Browse other questions tagged or ask your own question.