This seems like something that should be simple, but I can't figure it out.

I have an excel spreadsheet being used as a time sheet. I am using drop down lists to select a job code using lists and data validation.

However, I would like to set up a drop down list where when a user selects the description for a job code, it automatically places the job code in the drop down cell.

for instance: Let's say I have two lists side by side. The first list is descriptions (Holiday) and the second list is codes (PX1430.) I would like a drop down list so when a user selects "Holday" it automatically put the code in the cell.

How is this possible?