R
R
rootiys2016-10-15 14:02:00
Google
rootiys, 2016-10-15 14:02:00

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

1 answer(s)
R
rootiys, 2016-10-15
@rootiys

Understood. Made through the pivot table.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question