Google Sheets FILTER function (multiple columns) HD

So, this is what the filter function does. Understanding it is pretty easy, where should I actually use it? Here are a few ideas: - replace VLOOKUP and do a lookup to the left - replace SUMIF or VLOOKUP when filtering on multiple criteria - simulate what a pivot does and filter according to the contents from a cell How do you use this function? Let me know in the comments.