Answer the question
In order to leave comments, you need to log in
Google Sheets - How to reference data from another sheet with specific cells?
There are 2 tables - Table 1 and Table 2.
Table 1 contains data in 2 columns:
Apples Supplier 1
Plums Supplier 2
Watermelons Supplier 1
....
It is necessary to transfer all rows in which Supplier 1 is in table 2.
So:
=IMPORTRANGE( "1N69gOQ46iVRI3h5dWWnC2AHNIEQYEISBXgs9Q25Dv1s"; "Sheet!A1:A200")
=IMPORTRANGE("1N69gOQ46iVRI3h5dWWnC2AHNIEQYEISBXgs9Q25Dv1s"; "Sheet!B1:B200")
all data is transferred to table 2.
How to make a condition so that only rows in which Supplier is 2 are transmitted?
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question