Hello
I want to use the option "Data/Validity" with "Cell range" to make a selection list that will contain a cell range that is filtered.
Example: I have a district dropdown list that works fine and I need to make another dropdown with cities but I need to display only the cities in the selected district.
I tried VLOOKUP but this function returns a single value, a need a function that returns only the matching values for that district.
Thank you.
[Solved] Function that returns a cellrange
[Solved] Function that returns a cellrange
Last edited by robleyd on Sat Sep 11, 2021 6:43 am, edited 1 time in total.
Reason: Tag [Solved]
Reason: Tag [Solved]
OpenOffice 2.4 on Ubuntu 9.04
Re: Function that returns a cellrange
You seem to need a dependent drop down list - similar posts via this forum search may help you.
Cheers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
David
OS - Slackware 15 64 bit
Apache OpenOffice 4.1.15
LibreOffice 24.2.2.2; SlackBuild for 24.2.2 by Eric Hameleers
Re: Function that returns a cellrange
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice