Hello All,

I am trying to find a way to classify a budget where each item has a description that is a complex string with a key term in it.

I am trying to find a way to search each description for a key term (there is only at most 1 term per description) and based on that term automatically fill in two other cells that correspond to classifications. For instance a budget item would be "amazon web service transaction#31748109 account #784109721" in one cell (however the name would not always appear at the beginning) and I would want it to find amazon web service and match that to the entries "online" and "amazon" in two other cells. I have been told the way to do this is using an array but I have not yet succeeded using one.