How to import data from one Google spreadsheet to another with a condition, or how to set a key import condition in a formula?

Question

Data transfer

In Google spreadsheets, it is required to import from table A into table B only those rows that in column 2 of table A have a certain attribute (key), for example "3". I can only display all the data: select * ") everything else that I don’t try gives errors of syntax or something else. I don’t know how and I don’t find examples. Please tell me! Thanks in advance.

Answer 1

there is a built-in scripting language