Drop Down Issue - multi level filter

**burblecut** · 08-19-2010, 04:22 PM

I have created a worksheet in which I want to Look up a function, and match it with the location and name.

Problem is, I will select a function from my drop down list, and it will show the individuals with that specific function. Now I want to select my Location dropdown, to see which employee is in a certain city. When I do this, My other dropdowns reset.

How do I get it not to reset itself?
Cheers

I hope I explained this properly. I have attached my template

**NBVC** · 08-19-2010, 04:43 PM

You created a list (Data|List) for each separate column.. clear those (Data|List|Convert to Range), then re-create the list (Data|List) for all 3 columns together.

**meyero90** · 08-19-2010, 04:48 PM

I looked at your spreadsheet and I will assume that Abbott Shelley belongs to Treasury in Red Deer. I've created another "true" master list pasted next to the original one. now you'll see you can filter your name it will return function + location.