Dependent dropdown from a sorted list.

[flogmat]

I have two columns on sheet 2 with data. For this example, we'll say that column 1 has job titles and column 2 has job responsibilities. I'm trying to create a drop down list on sheet 1 where you can choose a job title to reveal its responsibility.

The problem is that there are multiple responsibilities for each job title, so I cannot use VLOOKUP as there are multiple cells for each job title. How can I create a drop down that will bring up all cells that I want associated with that value?

[Mazzaropi]

Dear flogmat, Good Evening.

I did a example spreadsheet to you..
I believe thatīs working as your desire.

Please, fell free to ask anything about it.

The Excel 2003 file is here: 03-09-2010--Mazzaropi_Helping_FLOGMAT.xls


I hope it can help you in your job.

[DonkeyOte]

Mazzaropi - please upload files to this server directly (not 3rd party).

[Mazzaropi]

Dear DonkeyOte, Good Evening.

Thank you for the information.

I uploaded the file to this server directly as informed.


The NEW link to Excel 2003 file is now here: 03-09-2010--Mazzaropi_Helping_FLOGMAT.xls


Have a nice weekend.