Dependent Data Validation List with Dynamic Range

Hello All,

I have searched forums and might have go the answer here (http://www.contextures.com/xlDataVal02.html#Dynamic) but I'm unable to put this into my excel sheet.

Please see attached sheet.

I want to be able to use the dynamic list with the INDIRECT function.

Please advice!

Thanks!

one correction, the named range ALLSitesDashboard2 should have this formula =OFFSET('Site-Location Mapping'!$G$25,,,COUNTA('Site-Location Mapping'!$G$25:$G$44))