I was creating an accounting log, so right now I'm using:


The first two criteria in the filter function check if the range is within a specific date range, and the final criterion checks if the type of transaction is relevant. But it's not letting me compare multiple values so I have to keep repeating the filter function.

Posting the same formula for more clarity


Is there a way for me to just compare if the transaction done is "Nuts, Bolts, Screws or Clips" in one go without having to repeat the filter function?

1 Answer 1


Can't test if it will work without a sample spreadsheet, but try

     MATCH(Transactions!E:E, Summary!C65:C68, 0)

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.