If, then, lookup? Excel 2010

[ddw23]

Hello I have a large worksheet and I need to input category codes in one column based on certain description words in another column. Example: If column D contains "cleaning" then enter "12345" in column B of the same row.
I'll need to change this frequently for the different category codes that need to be input and descriptions I need to search. I would do this in Access but the Administrator and the Assitant Administrator do not like Access. And because this is a large worksheet (and project), they are assisting in putting the proper category code with its associated description. Is there an easy way to do this in Excel? Maybe I should just ask what would be the best way to do this in Excel?

Thank you all in advance for any help you can provide!

[Tony Valko]

Sounds like this is what you're wanting to do:

http://contextures.com/xlFunctions02.html