Fill a column with values based on a search

Question

I have 2 columns

• name
• age

On another sheet, I want to create a column that lists all the names whose ages are over 30.

Is there a function that allows me to do this?

Answer 1

use:

=FILTER(A:A; B:B>=30)

or:

=QUERY(A:B; "select A where B >= 30"; )