Matching multiple rows in a google sheet

Hi, I have a google sheet that has non-unique keys. How can I match all rows that match the key? Or, how can I set up composite keys (multiple columns) to match by?

Basically, in google sheets integration, you can get only 1 record if conditions match with 2 or more records.

for composite keys, “cocatenate” 2 cells into 1 and search for it.

For more Database-style use, I recommend to use Airtable.

Thank you for the suggestion to use airtable.

How can I escape the curly bracket to use the airtable filter method?

image

I’m not sure about your table, in my old skill that use airtable and filter by 2 keys(name and department are column headers), like this.

AND(name = "{worker}", department = "{department}")