Drop down based on multiple validation lists

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