I am working on a spreadsheet for our finances with different entries. I am working on setting up rules or a long formula to help me out, I want it to read the transaction and if it has certain workds than in another cell list it as an account. . I want it to read the test in A1 (if it says "ATW" or "CW Feed" or "xyz" than enter "Farm" in A2. I hope thatt his makes since. Any help is appriciated.

Thanks