What's the Excel equivalent to Google Sheets' FILTER(range, condition)?

One of the benefits I am seeking is that the formula allows you to return a big range of data from i.e. another sheet, but the formula itself only occupies one cell.