Drop Down List to Autofill cells

[jdominga]

Greetings!

I am not sure if this is possible but, I would like to auto-fill cells based on what I select from a drop down list.

For Example:

Drop Down List is located in A1(already created). Let's say it lists items like bathroom,front of building, dinning room etc.

I have created on sheet 2 a list of responsibilities for each item on the drop list. The list has a header for example bathroom and a below it list the responsibilities. I did this for every item on the drop list.

Now, is it possible to select bathroom from the drop down land when selected the list I created in sheet 2 show up in the cell next to bathroom? Also, is it possible to have this happen every time i select a different item from the drop down list?

Thank you,

Jenn

[Fotis1991]

Yes it's possible. Can you upload a small sample workbook?

[jdominga]

I think i figured it out. Please let me know if you could see the attachment?

[Fotis1991]

Hoping that i understand well your request, take a look to the example.

[jdominga]

This is exactly what I needed. Thank you soooooo much for your help!!

[georgeexcel]

Can you please help me.. I have a drop-down list and what i want that when i select an item returns values in a specific cells in the same row where the item selected is located..

Thanks in advanced

[oeldere]

@georgeexcel

make your own question and refer to this one if it is usefull.