=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"))