Sample spreadsheet here.
In the spreadsheet, there is a dependent drop-down list in the first column, which automatically populates a data validation for the second column using the named range from the first column. This works fine, but any named range with space (e.g. Eating Out) has to be displayed as (Eating_Out or Eating.Out) since named ranges do not accept spaces. Is there any sort of workaround for this?