Office 365 Won't let me have a none absolute cell reference in the Data Validation

Been beating my head against a wall for a few days trying to figure out how to get a dependent drop-down list to function in the Desktop Office 365 version of Excel.   I've finally found something ...