Hi folks,

I'm working on a project that I need some help with a certain formula. This is what I am trying to acheive.

I want to create a dropdown list that when I choose a title such as "cleaner" the adjacent cells will automatically input the rates for a cleaner, as displayed below. When i choose "labourer" on the drop down list, the rates for a labourer will automatically show in the adjacent cells.


Description Rate Overtime Rate
Cleaner 25.00 37.50
Labourer 30.00 35.00

Can someone help?