I have posted a question previously but not sure if this the way to do it again.
Anyway, I would like to create a drop down list which selects a list of data depending on the cell before it.
I attach a sample spreadsheet.
If Fab1 is selected in the drop down list cell c1, rhen the DRop Down lIst in D1 would have BLue Green and Red as the options. If however, Fab2 was selected, the colours in the DDL would be Blue Purple Grey.
It's probably dead easy, but I'm just not quite getting it ...... ( I hope its not a huge formula thats needed... IF( ....) etc as tried this and could not get it to work)
Mods01350
[Solved] Conditional drop down list
[Solved] Conditional drop down list
- Attachments
-
- how to do indirect drop down.ods
- (8.2 KiB) Downloaded 1129 times
Last edited by Hagar Delest on Thu Feb 19, 2009 11:50 pm, edited 1 time in total.
Reason: tagged [Solved].
Reason: tagged [Solved].
OOo 3.0.X on Ms Windows XP
Re: Conditional drop down list
An example with cities of selected country: http://user.services.openoffice.org/en/ ... php?id=333
menu:Data>Validation...
menu:Data>Validation...
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
Re: Conditional drop down list
Thats just fantastic. Thanks Villaroy.
Can you reccommend a good text for in depth explanations and examples of the use of formulas in Spreadsheets, or a good on-line resource?
Can you reccommend a good text for in depth explanations and examples of the use of formulas in Spreadsheets, or a good on-line resource?
OOo 3.0.X on Ms Windows XP
Re: Conditional drop down list
Get "Excel'97 for newbees" or any book like that from the flea market.
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
Re: [Solved] Conditional drop down list
Just use double quotes instead of single quotes in the validation of D1.mods01350 wrote:could not get it to work
AOO 4.1.15 & LO 24.8.4 on Windows 10