Hi! I seem to be failing to get correct results using SEARCH() and FIND(). Let’s say I am using the formula “=SEARCH(A1,A:A)” where A1 is “Apple”.
I put this formula in cell B1, it returns “1”.
I put the exact same formula in cell B2, it returns “!VALUE”.
I put “=SEARCH(“Apple”,A:A)” in cell B3, it returns “!VALUE”.
Shouldn’t all three return “1”?
And why did you use it with A:A the whole Column A as second Argument??
SEARCH and FIND look up a string within one cell. In this particular case where you reference a whole column, it looks up the string in the single cell at the same row position.
example_SEARCH.ods (10.0 KB)
Thank you, that makes sense! What is the correct way to search a whole column?
Maybe
=MATCH("apple";A:A;0)
I ended up using COUNTIF(A1,A:A), this worked fine.