# [Calc] interactive drop-down? [closed]

Hi guys,

I'm not sure if what I want is possible, but maybe anyone of you can tell me if it is.

Lets say in Calc we create 2 tabs. In the second tab I would like to create "categories" with options, for example:

```
A B
1 color size
2 red small
3 blue medium
4 green large
```

The first row acts as a "category", in this case "color" and "size" and the underlaying cells are the options for that specific category. Now what I would like to do, is on the first tab being able to select a category. Once I picked a category, in the next cell I would like to choose one of the options, so you get something like this:

```
A B
1 CATEGORY OPTION
2 color blue
3 size small
```

Can this be done?

May be you mean =VLOOKUP($B$2;$Sheet1.$A$2:$B$4;2;0)?