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.
[Dropped] How to return cell content..
-
- Posts: 1
- Joined: Fri Sep 17, 2021 9:57 pm
[Dropped] How to return cell content..
OpenOffice 7.0.6.2 (x86) on Windows 10.0
Re: How to return cell content..
You can use the formula
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
Code: Select all
=VLOOKUP("apple";F1:F10;1;0)
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Re: How to return cell content..
ValidUsername,
please upload your ODF type sample file here.
please upload your ODF type sample file here.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.