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.