Dropdown that feeds to two other dropdowns with the same Name Range

**rojamilo123** · 02-10-2016, 06:29 AM

Hi there,

I have a dropdown where someone fills their name in from a dropdown in cell A1 and this determines the options from a dropdown they can enter into B1 (using the INDIRECT function). I also want a dropdown for cell C1 based on the info from A1 also. The problem I have here is that I can't name range two different sets of data the same thing.

Example.

A1 - You pick your name from a dropdown - ie. Joe Bloggs
B1. I have a name range called Joe Bloggs that then enables him to pick the site he is working on based on a list of Joe Bloggs available sites - ie. London
C1. I want Joe Bloggs to put his employee number but cannot name another range Joe Bloggs as the info for B1 has a name range of Joe Bloggs.

I hope this makes sense. How do I get round this?

**dflak** · 02-12-2016, 05:37 PM

Try this concept: make a range that has the same name with some sort of a suffix and concatenate the suffix in the indirect. See the attached.

**newdoverman** · 02-12-2016, 09:22 PM

You could make use of a vlookup table that has the names down the first column and every column after the name would have a name corresponding with a drop down. The first column of the table would be the list from which the names are chosen in the first drop down, the second column would have a second name for each name in the first column and the third column would have another name for the name in the first column. Each of these names would of course have a table of choices. You will very quickly be creating a lot of tables.

This small example shows the possibility of the above