Hello All,

New and young technical writer in a bit of a stew due to my inexperience with MS Excel formulas. The following outlines what I am attempting to do, likely very basic to you gurus out there so please forgive my newness to this.

In my worksheet, Column A contains a repeating series of drop down menus created using data validation. The choices int he drop downs are the names of courses offered by my training department.

In Column B I would like the number of billable hours each course is worth automatically entered based on which course they entered in column A. I know there is a simple formula to achieve this but I simply am hitting walls so far.