Thank you so much, any look-up function other than "vlookup/hlookup" confuses me.

I do have one problem, though: there's no way I'm going to be able to get those headers in the same order on both the "Summary" and "Database", too many different ways of verbalizing the different duties, employees, etc.

Would it be possible to create a formula where the headers (above the columns and next to the drop-down) options do not have to be in the same order? Possibly via some sort of "index/match" function?

Sorry if I seem ungrateful, I'm just on a tight deadline; I appreciate all the help this forum has given me over the last few months.