I have a Categories sheet and a Statement sheet. The Categories sheet contains a list of all possible categories, and the Statement sheet is an export of my credit card. How can I automatically categorize the purchases based on keywords within the description?

Categories Example:

enter image description here

Statement Example: enter image description here


1 Answer 1


Use filter() and search() or regexmatch(), like this:

=+filter(Categories!B$2:B, search(Categories!A$2:A, E2))

See filter(), search() and regexmatch().

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.