Thursday, December 26, 2013

yogi_Use QUERY Function Using Named Ranges For Source Data And Field Name(s)

                                          Google Spreadsheet   Post  #1448
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Dec-26, 2013
question by Isai Alvarado (!category-topic/docs/spreadsheets/urtd8hGGOvk)
Query formulas with cell references HELP

If I type =query(PTS," "&E8&" "

and E8 has 
select A,B,C where (A='P' and B<8 and C>=2), the formula works.

However, if E8 has a named range select A,B,C where (A='P' and B<"&csp&" and C>=2), it doesn't recognize the named range.

Is there a way to make the query function recognize the named range csp that is inside E8?

Example spreadsheet: