Cascading drop down list

Hi all. I know that this thread is multiple times posted but i wasn't able to take what i wanted.
I have an excel sheet that contains horizontally the multiple departments of a company that splits on the various subdivisions and later on on the various role positions. The list is horizontal and what i am trying to achieve is a cascade drop down list so that the user first selects the department, and on the next cell the list to be updated with only the subdivisions available on that department and finally based on that selection to be able to select on the next drop down list the roles specific on that department.
I tried a lot of online tutorials even with macros but couldn't get what i wanted. Any help appreciated.

Firstly thank you for the response and the information provided.
Basically, i tried defining lists on name manager but there are a lot
of possible combinations to be able to define so many names. Also
i tried extracting the filtered results of the second column
based on the first column choice and then input them as data
on data validation for the second drop list, again without any
success.
In the dummy attached i replaced all data with fake for obvious reasons.
The first selection is the name of the country, which will eliminate
the results to only the specific to that choice for the next
selection and goes on.
If there still are more questions for clarifications please let
me know.

Unfortunately this is the given structure, because the next step is to extract some information which are provided on each case chosen and which are written on the same row.
The choices are not binary and as you correctly guessed i did an oversimplification.
There are 4 levels and the choices on each level are a lot..
I actually found this https://www.extendoffice.com/documen...ist-boxes.html link which helped me a little but it is kind of buggy on the results.

Ok i will try to elaborate even more on the overall task i have to do. Updated excel is attached.
I have supposedly two group of data. The first group indicates the current position of a person and these data have to be selected from the user using lets say a drop down list. There are four levels of selection but the last level is unique for each case so there is nothing to choose from. This is the reason i didn't include it in the original excel. The choices are NOT binary and there are plenty of choices but given a bad example i chose the gender case.
Each choice that the user finally makes, results in 3 characteristics. These has to be printed somewhere, for example next to the Own characteristics cell i provided.
The next task is to try and find the possible destinations located on the second table and the criteria for that is to have a 2/3 match on the data provided for each case on the second table. These possible destinations are to be printed and provided to the user as outcome.
This is the task i try to do.
Regarding work sheet events or helper columns i really have no preference as long as this is viable..
Again thank you for assistance.

Ok never mind about countries and genders :p I have four level cascading drop down list that each choice has to contain filtered data based on the previous choice. The data are in horizontal structure like i provided. Each final choice after completing the four choices has a corresponding 3 data cells.
These cells must be compared with the corresponding three data cells on another table and where i have a match (e.g. where at least two out of three data) the choices of the second table will be extracted e.g. as shown next to the Possible Destinations part.
I expect to see the percentage match next to the second table as shown on the example and next to the possible destinations to see the cases where there is a match greater than 2/3.
The rows for the drop down list are in total 57.

Yes. I am using definitely Office 2013 and above.

Apologize. Just changed it.

Gleen Kennedy,
You are right. I am not satisfied with that solution either. I have been stuck on that for days and that is the best I could find so far, besides a script on Google Sheets (which is exactly what I want, but I need it for Excel unfortunately).
I have only been using Excel for about a month, so I have a lot to learn.

I did find this other workbook that someone posted on another forum years ago. They auto populate information from one data table onto helper columns and use that as the data source. But I do not know how to tailor it to this person's situation, or my own for that matter, or if that's even what they are asking for.

I'm just throwing stuff out there trying to help since others have helped me.

Here is that workbook I found, I am not sure if it will be of any help as I mentioned. I apologize if it's useless to you.

First of all thank you for the valuable response and the solutions provided. All of the solutions were exactly to the point and i think this thread will be valuable to others as well.
Glenn you got the point and thank you.
Even though the solutions work, i prefer working with macros instead of formulas. So i kept the kvsrinivasamurthy solution who i honestly thank.
I added the Target.Offset(0, 2) = "" on the first part of the code so that the rest of the choice cells to be cleared also when the user makes the choice on the first one.
The only bug i find is that when i replace the name Set SecRng = Range("C3:C25") with Set SecRng = Worksheets("Sheet2").Range("C3:C25") does not work and the outcome is kind of messed up. When i try this on the same sheet it works fine. Is the Intersect function buggy when the source data are in another worksheet?

Please Login or Register  to view this content.

This is your code but modified based on the actual needs. The results are that only the first choice cell has a drop down list and the others don't. Also the drop down list with the same data is created on other "random" cells of the same row.