[Solved] Function that returns a cellrange

victorqed · Post by **victorqed** » Fri Sep 10, 2021 1:32 pm

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.

Post by **robleyd** » Fri Sep 10, 2021 1:46 pm

You seem to need a dependent drop down list - similar posts via this forum search may help you.

edit this topic's initial post · Post by **Villeroy** » Fri Sep 10, 2021 4:45 pm

http://forum.openoffice.org/en/forum/do ... php?id=333

victorqed · Post by **victorqed** » Sat Sep 11, 2021 6:34 am

It works, thank you.

[Solved] Function that returns a cellrange

[Solved] Function that returns a cellrange

Re: Function that returns a cellrange

Re: Function that returns a cellrange

Re: Function that returns a cellrange