Tag: inner join

Filter one table if the value is in another table (Formula Trick)

I have an orders table and want to see only orders from a given list of products. We can use Excel’s FILTER function to do this.