Working with a cash worksheet that I list deposits and expenditures. Need to
add accounting code column with an assigned number dependent on
nature/description of expenditure. Is there a way for certain key words (in
some cases multiple key words) to trigger an accounting code number in the
appropriate cell? For instance Account code '3' may include rent, hotel,
housekeeping, utilities etc. Would like the formula to check for any of
those words and put '3' in the cell recording the relevant accounting code.

Thanks