EXCEL HELP PLEASE

i am trying to make a spreadsheet for my work (alltel) and what i need is to find/make a funtion to make someones job much easier…. when we pull spreadsheets it give us product description and doesnt display what the commission is for the product…figuring commission they manually have to enter the dolloar amount and move down till they are done for the whole month of sold products..many of these are very repeatative and time consuming. is there anyway i can do an “if” like function that when it says a certain product name…the amount of commision will be displayed in the next cell thus letting them auto sum the total without any chance for manual error?