Error Query completed with an empty output-CodePudding

=ARRAYFORMULA(QUERY(IMPORTRANGE("https://docs.google.com/spreadsheets/d/1I57M2dP-q_fL5YCNJwAxPmkmdPV1e8SoESWvYGhsfW4/edit#gid=0","PROCESS REJECT!A3:N"),"select Col2,Col3,Col4,Col5,Col8,Col11 where Col3 = '"&A1&"'")) I am trying to get the data from this cell that acts like a search bar and output that data in this sheet

I am trying to get the data from this cell that acts like a search bar and output that data ienter image description heren this enter image description here

CodePudding user response：

Please try this out:

=ARRAYFORMULA(QUERY(IMPORTRANGE("1I57M2dP-q_fL5YCNJwAxPmkmdPV1e8SoESWvYGhsfW4","PROCESS REJECT!A3:N"),"select Col2,Col3,Col4,Col5,Col8,Col11 where Col3 = "&A1&""))

CodePudding user response：

first use:

=IMPORTRANGE("1I57M2dP-q_fL5YCNJwAxPmkmdPV1e8SoESWvYGhsfW4"; "PROCESS REJECT!A3")

connect your sheets and then use:

=ARRAYFORMULA(QUERY(IMPORTRANGE(
 "1I57M2dP-q_fL5YCNJwAxPmkmdPV1e8SoESWvYGhsfW4"; "PROCESS REJECT!A3:N");
 "select Col2,Col3,Col4,Col5,Col8,Col11 where Col3 = "&A1*1; ))

this will work only if your column C is numeric. you can check this like:

=ISNUMBER(IMPORTRANGE("1I57M2dP-q_fL5YCNJwAxPmkmdPV1e8SoESWvYGhsfW4"; "PROCESS REJECT!C3"))