VBA lookup based on current cell contents dropdown list

[will31]

Hi All,

I am designing some simple time sheets to capture direct time. What I would like to do is to have a description of an activity to come into a box at the top of the sheet when they are flicking through the dropdown list.

Is this doable? I guess it would need to be related to the contents of the currently selected cell and not have errors if this cell in not in column C

thanks in advance