Home » Forums » Open Source Learning Center » Question and Answer

Update a dropdown based on previous cell

Submitted by harish on 16 November, 2012 - 12:35

Hi All,

I need to update a drop down based on previous cell..

for example
In sheet 2 i has

product name version

a 10
a 11
a 12
b 10
b 11
b 12

and in sheet 1 as

name version as two columns and if we give name as 'a' then version should get a drop down showing all versions of only product 'a'

if name as 'b' all versions of only product 'b'

its an urgent plz help..

‹ Formula or macro Demo Wordworkout Game ›
»
Almir's picture

Use Data Validation with some formula

Submitted by Almir on 16 November, 2012 - 13:14.

On "Sheet 1" select cell with version (in this example E3), go to "Data"=>"Validation".
Choose "List".
In Source enter this:
=IF(E3="a";RangeA;RangeB)

RangeA: select versions of product "a"
RangeB: select versions of product "b"

Copy cell down. You will get "smart list": for product "a" you will get drop-down menu of only "a" versions. The same for b etc.

»

thanks for the reply, where i

Submitted by harish on 16 November, 2012 - 13:24.

thanks for the reply,
where i need to add RangeA and RangeB

»
Almir's picture

Where to add RangeA and RangeB

Submitted by Almir on 17 November, 2012 - 09:05.

In Data Validation window, when you paste formula, instead of RangeA, select versions which have "a" in left column. For RangeB select versions which have "b" in left column.
Did you manage to do this?

»