[Dropped] How to return cell content..

[ValidUsername]

from within certain range, only if the cell contain certain values?
say, if I want cell A1 to return the content of the 1 cell in range F1:F10 which contain the word "apple".

I've read the relevant help files and tried different functions for hours but didn't find quite what I am looking for.

[FJCC]

You can use the formula

Code: Select all

=VLOOKUP("apple";F1:F10;1;0)

I assume you want to match a cell that has apple anywhere in its text. For that to work, you need to have Calc match on the partial content of a cell. Go to the menu Tools -> Options. Expand the Calc list on the left and select Calculate. Remove the selection from Search criteria = and <> must apply to whole cells

[Zizi64]

ValidUsername,
please upload your ODF type sample file here.