I am looking to link several lists to make it easy for users to categorize issues. I have included a file that shows a sample of the 3 levels that I need to link together in dropdown lists. The fourth level needs to be able to be applied to all Level 3 values. Level 4 defines what went wrong as related to level 3. I looked into using vlookup and INDIRECT formulas that would work with multiple words in a list value. Any help would be greatly appreciated.