Thursday, October 25, 2012

yogi_Query Sheet1 For User Specified Criteria And Present Resulting Table In Sheet2

                                           Google Spreadsheet   Post  #827
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Oct 25, 2012
user esmithnola said: (!category-topic/docs/spreadsheets/fN5cQZeLs24)
Query returning all matches in a single cell, please help!
If you want to see my sheet and formulas, you can access/edit at 

I've written a query where my Sheet2 goes to look in Sheet1 and returns columns A, B, AV, CC when column AH or AJ match a value input in B3 on Sheet 2
=QUERY('Sheet1'!A:CC;"select A,B,AV,CC where C=11 and (AH <='"&$B$3&"' or AJ <='"&$B$3&"') order by B")

It works, but it returns all the values in a single cell instead of a new row for each match (normal behavior). Any thoughts? I've tried all sorts of things, but still the same behavior.

(Btw, in case you're wondering I'm trying to make a sheet where I can automatically pull certain students based on input criteria. All the information on those sheets is just made up.)
following is a solution to the problem