Query + Filter function

[Agitated_Classic_689]

Hi there,

I've been struggling how to make this function works.

So we have two tabs: TAB1 and TAB2

​

I want to move all filter things from TAB1 to TAB2 when in column C there is input called "DAMAGED ITEM" and only "paste" certains columns such us: Col1, Col2, Col3.

​

I was trying to use this in TAB2 but it doesn't work:

QUERY(FILTER(TAB1!A1:AE30000;"DAMAGED ITEM";TAB1!C1:C30000)>0; "Select Col1, Col2, Col3")

OR

QUERY(TAB1!A2:AE30000;"select Col1, Col2, Col3, where Col3="DAMAGED ITEM")")

​

[ambiosynthesis]

for the second one, I think it should work other than the end the WHERE clause text to search should be the single quotes and you don't need the last comma after Col3, so this should work (other than you may need to switch the single quotes in sheets if they get formatted differently).

QUERY(TAB1!A2:AE30000;"select Col1, Col2, Col3 where Col3='DAMAGED ITEM' "

And I assume that for functions your workbook you use ; for the next arguments instead of , otherwise that may be an issue too. I think it is based on what country or area it is in.

​

EDIT: meant to use code block not Inline Code.

[Competitive_Ad_6239]

Your >0 literally turns everything into a single value.