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     www.energyefficientbuild.com.   Dec-26, 2013
question by Isai Alvarado (http://productforums.google.com/forum/?zx=e80jmfn2nptg#!category-topic/docs/spreadsheets/urtd8hGGOvk)
Query formulas with cell references HELP
Hi,

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: https://docs.google.com/spreadsheets/d/1k_kVqHjI_6oAqARq3zgieMpanfwTZJJIJCfxUqhoxxE/edit#gid=0

-------------------------------------------------------------------------------------------------