Ask Your Question
0

Items of selection list based on field value [closed]

asked 2014-02-21 21:42:47 +0200

Brenne gravatar image

Hello,

I want to insert a selection list in Calc. The list items should depend on a value of another cell. For example when value of cell 1 is 'A' then the selection list should contain 'X', 'Y' and 'Z' but
if the value of cell 1 is 'B' then the selection list should contain 'K', 'I' and 'J'.

I want to make it as simple as possible.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-19 11:31:52.580085

1 Answer

Sort by » oldest newest most voted
0

answered 2014-02-21 22:27:59 +0200

Brenne gravatar image

Okay I found the answer in a youtube video http://www.youtube.com/watch?v=-x6Vbuo3kUM .

I assume cell A1 contains the value my selection list should depend on and in cell A2 the selection list should appear with list items depended on the value of A1. Enter the item values of your selection list e.g. on a seperate sheet. Select all cells you want to make dependend on the value of cell A1. In my upper example this would be X,Y and Z on the one hand and K, I and J on the other hand. If you have selected the the values click in the name box and give them a name for example 'Values1' and 'Values2'. Select Cell A2 and go to Data->Validation->Allow->Cell Range. In the field source you enter:

IF(A1="A",Values1,IF(A1="B",Values2))

If you don't understand my answer I recommend watching the youtube video.

edit flag offensive delete link more

Question Tools

1 follower

Stats

Asked: 2014-02-21 21:42:47 +0200

Seen: 3,536 times

Last updated: Feb 21 '14