I'd like to assign category based on partial text using a lookup table. Please see the attached file. In the desc column in the Data tab contain text I want to look up. For example, any line contain the text "ABC" will be assigned to "Category 1" (see table on the lookup tab). I assume it can be done with formulas.
In the future, I might add an account column next to desc and expand the lookup table with an account column. Then I would like to lookup categories based on text AND account. Is this doable?