For the Car maker model, you wouldn't really need to list the duplicated. You could make a named range that involves only one of each type of car. From there, the model, trim, and model year can be created using dependent named ranges.