use the same principle for the next validation, i.e. create range names that are the same as the door styles and list the finishes applicable to that door style in the named range, then use indirect for the door style to get the list of finishes.

If that does not help, post a (small) sample workbook.

hth