Hi All,
Hoping you can help with the following please. I need to be able to present a list of engineers capable of performing a role based on the support area and the level of experience. To add an extra element, some of the engineers are capable in multiple areas.
I've created a number of named lists such as:
Support_Area : Server, Network, Storage
Role_Level: Junior, Mid, Senior
Along with individual named lists which contain all the engineers for each support_area, role_level. I.e.
Server_Junior {Engineer 1, Engineer 2} ; this references A3 down
Server_Mid {Engineer 3, Engineer 4}, this references B3 down
Storage_Junior {Engineer 2, Engineer 12} ; this references I3 down
What I have so far a drop-down in Column C (Support_Area) , followed by drop-down in Column D (Role_Level), the Column E (Engineer) needs to present a drop-down list (such as Server_Junior) of the relevant engineers capable of the earlier 2 selections.
How would I go about getting the column E populated with a drop-down list without putting in a rather excessive IF statement for every scenario?
If it's not possible to do it the way I've currently go it, what are the alternatives?
Appreciate any help.
Cheers,
March
Hoping you can help with the following please. I need to be able to present a list of engineers capable of performing a role based on the support area and the level of experience. To add an extra element, some of the engineers are capable in multiple areas.
I've created a number of named lists such as:
Support_Area : Server, Network, Storage
Role_Level: Junior, Mid, Senior
Along with individual named lists which contain all the engineers for each support_area, role_level. I.e.
Server_Junior {Engineer 1, Engineer 2} ; this references A3 down
Server_Mid {Engineer 3, Engineer 4}, this references B3 down
Storage_Junior {Engineer 2, Engineer 12} ; this references I3 down
What I have so far a drop-down in Column C (Support_Area) , followed by drop-down in Column D (Role_Level), the Column E (Engineer) needs to present a drop-down list (such as Server_Junior) of the relevant engineers capable of the earlier 2 selections.
How would I go about getting the column E populated with a drop-down list without putting in a rather excessive IF statement for every scenario?
If it's not possible to do it the way I've currently go it, what are the alternatives?
Appreciate any help.
Cheers,
March