The FILTER function
ExpertExpert
10 questions, about 18 minutes
Fetch every row that meets a condition, instead of just one as with VLOOKUP.
What we'll do
- Filtering with a condition
- A message when nothing is found
What you'll use
FILTERSORT
How it works
In an example you watch and don't need to fill anything in. You answer a question yourself. If it goes wrong, you get a tip, then a hint and finally the solution.
2examplesYou watch
10questionsYou do it yourself