How to display a range of values ​​from one sheet to another with a condition?

Question

excel

Greetings! I ran into a difficulty: it is necessary to display a certain range from another sheet on one of the sheets of the table. Understood this. However, you want the output to be only those rows whose cell value is equal to a certain value.

The function must be of the type:
={'All chairs'!A:H} if H is equal to "Bar"

Answer 1

Good afternoon!
The Google Sheets function
=FILTER('All chairs'!A:H;'All chairs'!H:H="Bar chairs") seems to work.

Answer 2

=IF('All chairs'!H2="Bar";'All chairs'!A2;"")
etc.