Multiple excel drop downs that populates answer

This is a two fold question. But first, a bit of background. I want to be able to quickly select from four different drop downs which then populates a value. The value is already in the table but it can take a minute or two to find manually.

Firstly, when selecting the first option on the drop down I would like to limit the available options for the next and so on until the fourth box. e.g. if the first drop down was selecting days of the week or months of the year, depending on your selection the next drop down would only relate to that. So if you selected weeks in the first box, only the days of the week would appear in the next.

The second problem is whenever those four drops downs are selected in a specific and unique order, I want to populate the unique ID that those relate to. So it's probably a lookup of some sort, I just don't know which one, or how to do it.

Your help is much appreciated.