Drop down based on multiple validation lists

Hi

Is it possible to populate a validation list , based on selections made from from three or more validation lists. see my attached example b

If you name the lists you can use the INDIRECT function to refer to the appropriate Source.
Say the three cells with Companies 1 to 3 under the 111 heading are named...
_111Cos
and similarly for the two other Company lists...
_222Cos
_333Cos

then on the Data Validation dialogue this formula will refer to the appropriate companies depending on the value selected in B12...
=INDIRECT("_"&$B$12&"Cos")

Beau Nydal

Here is a recent thread I participated in that dealt with this same issue. It is not an exact match, but the principals are the same.

http://www.excelforum.com/excel-gene...dropdowns.html

Do a Google search for Dynamic Data Validation List

Hi Miraun,

I think you've attached the wrong item, it's the jpg I attached.

Regards

Hi
Can anyone help ?
Thanks

Instead of attaching an image, please attach a workbook. This makes it easier to assist you, in that not only will it save the time it takes to type out everything you have in your image, but it will also allow us to check things outside of the scope of the image, like formulas, file properties, extraneous data. Attaching an image is rarely useful.

Also, did you do a Google search on Dynamic Data Validation List as I had recommended? Doing so will yield plenty of very useful information on your situation.

Hi

I did check out your recommandation , but it didn't seem to fit the task we are trying to achive here.

I have uploaded the worksheet example, which reflects the recent JPG.

The field in red is the issue.

thanks