A bit of a noob with Excel. I’m trying to help my department by making an assignment front sheet that will insert data based on the selections made. 

So far I have created a drop down list that will check for unit number (data validation -> list -> named range), which in turn adds the unit name (index and match named ranges) and shows only available criteria linked to that unit (data validation -> list -> indirect). The problem that I am having is getting the criteria descriptor to show up in the cell next to the chosen criteria.

I don't want to be using VBA or any macros as the staff and IT Techs are paranoid about security. A formula based solution would be great.

It probably makes more sense if you [download](http://1drv.ms/19H8O7r "spreadsheet file")(updated link) my spreadsheet. 

Thanks

AC