Dropdown menus with filtering?

**YohYas** · 02-09-2012, 12:46 PM

Hi

Please help me on this puzzle!
I work in a venue and currently arranging a spreadsheet to help maintanance. We have two columns (A & B). We are after both columns to have dropdown menus for users to select from.

I am currently using data validation in column A (a dropdown menu). Once the user makes their selection in column A, they will then move onto column B to select the location. It is in column B I need to have only those locations available to choose from. Hope this makes sense.

I have added an example of what I'm after. Please help me if you can

Thank you! YohYas

**Fotis1991** · 02-09-2012, 01:01 PM

Hi and welcome to the forum.

You need Named Lists and INDIRECT function for this.

Take a look to the example.

Hope to helps you.

**bebo021999** · 02-09-2012, 01:12 PM

@Fortis1991
Good job!
I could not find name List in Defined name! And data validation points to INDIRECT(An). How does it work?

**Fotis1991** · 02-09-2012, 01:37 PM

@bebo

Thank you for your good words. I'll try with my poor English(as you know),to explain what i did...

.

I have 4 names, that regards eatch one of these to a List.
1) _3RD_FLOOR_Admin_area(B2:B13)
2)Bar(C2:C8)
3)clasp_offices(D2:D7)
4)Dining(E2:E8)
Then in A17:A21,we use a Validation List with these.
Then, INDIRECT(in B17:B21), does the job!!

**bebo021999** · 02-09-2012, 01:49 PM

Thank Fotis1991,
I is quite new for me and happy to learn a lot from you.
Normally I use OFFSET to do this, so terrible and ugly perfomance!

**Fotis1991** · 02-09-2012, 02:01 PM

As you can understand, both of us every day learn something from eatch other but most of all we learn many new things from the experts in this forum..

So we keep learning...