formulasgoogle sheetsgoogle-sheets-filtergoogle-sheets-query
I need some help here.
So I need a function which imports selected columns from a different sheet out of which one of them contains a specified word but allows you to filter/ignore based on specified words
And here's the example sheet: https://docs.google.com/spreadsheets/d/1brWG_lbvqQUDT5x9ZGmxFKYUu6ByQ56SPi9Y9C21WBQ/edit#gid=1683245951
And this is the QUERY Function:
=query(Sheet1!A:F, "SELECT A, B, C, D, E, F where (E contains 'Apple')")
Thank you for any help.
Use a FILTER/MATCH combination. Example on your data below:
=filter(C52:F57; match(C52:C57; I53:I54; 0))
The "problem" is that the formula is using open references so there are a lot of blank cells from Table 1 above the Foo value.
One way to avoid having a lot of blank cells is to filter them out:
={QUERY(A3:B,"select A where A is not null AND B is null");QUERY(D3:F,"select D where(E='Yes' AND F is null)")}
Best Answer
You would just use and
The only column containing a different variable is column B. So you could use
Note:
you do not need the parentheses around
E contains 'Apple'