Wednesday, February 18, 2015

yogi_Pull From Data Brought In By Using ImportRange Those Rows That Have In Column F One Of The Entries In Cells A1 To B3

             Google Spreadsheet   Post  #1896
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Feb-18-2015
post by  Omar Kalaf:
ImportRange select everything that matches 6 of 12 possible entries in a spreadsheet
I have 1 spreadsheet that is my live data. In Col6 There are 12 possible options for cell content driven my data validation.
In a 2nd spreadsheet I am trying to pull some of that data in.
I am just wanting to pull data that matches 6 of those 12 possible cell contents AND ignore any empty cells
My 2nd sheet has the 6 criteria to match listed in cells A1 thru B3.
Trying this in cell A5 to pull the data but keep getting error.

=Query(ImportRange(ʺ1goG0TS1_2jwlGRetREYNRVk-Q6TEy3iWG_5VXFoZlusʺ,ʺMaster!A:Fʺ),ʺselect * where Col6 ='ʺ&A1&ʺ' or Col6='ʺ&A2&ʺ' or Col6='ʺ&A3&ʺ' or Col6='ʺ&B1&ʺ'or Col6='ʺ&B2&ʺ' or Col6='ʺ&B3&ʺ' ʺ,0)

It states unable to parse for Function Query parameter 2........

Any help would be most appreciated
--------------------------------------------------------------------------------------------------------------------------


No comments:

Post a Comment