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!
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!