2 x vlookup lists, with 1 controlling the data of the other, how?

[rdaviesmvp]

I am working on a piece of work where data in the background is populated on an info front sheet for other users. As there are multiple different topics, I want to create a list that controls what is then given in the 2nd list??

The 2nd list I have working to a VLOOKUP for one of the sheets, but would like the 2nd list to change depending on what's selected on the 1st list.

Any help please?

 

[NARAYANK991]

Hi ,

I have created 3 named ranges ALCOHO , CANCER , CHRONI , which take care of the first 3 choices in the first dropdown list.

These names may look awkward , but they are all restricted to 6 letters.

Each of them refers to the corresponding range in the appropriate worksheet.

You will have to create the remaining 14 named ranges to refer to the correct ranges on the remaining 14 worksheet tabs. These names will have to be the first 6 letters of the choices in the first dropdown list , unless the names themselves are less than 6 letters long , as in the case of Dizzy , Sleep etc.

Narayan