Heirarchal dropdown lists and multiple substitute functions in Excel

This is a postscript to an earlier video titled "Hierarchical dropdown lists and substitute functions in Excel". In this video, Ken Atigari shows how to nest a substitute function within another substitute function when working with data validation and name manager in Excel.