I’m creating an employee contact list and would like to be able to enter or select a Job and then have another cell populate the Department that corresponds to that Job.
For example, as I enter a new employee into the table, I’d like to be able to se...