Arrayformula and If: how to sip data, given the conditions in a Google spreadsheet?

Question

Google Sheets

There is a task: to take data from different sheets of the same book, comparing the text in the cells by one parameter.

Writing:

=Arrayformula(IF("Адрес столбца" = "адрес сравниваемого столбца)..

And further difficulties with syntax.

Please help with an example.

Answer 1

Perhaps you need them:
FILTER( range; condition1; [condition2; ...] )
QUERY( data; query; [headers] )