Saturday, May 4, 2013

yogi_Pull Select Information From A Table Based On Specified Fields (Columns)

                                          Google Spreadsheet   Post  #1170
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May 04, 2013
user StudentSupport (http://productforums.google.com/forum/?zx=489otlptm5fw#!mydiscussions/docs/OsltWNvu2Dg)
I am trying to pull data, but with user selected input. If a user decides they want to view data from a certain column on another sheet then they can put an "x" in a cell. I have a helper column that helps write the formula prior to pulling the particular information.

="select C, D, E, F, G, H where B1:B="x"", which gives me a parse error.

Please view: https://docs.google.com/spreadsheet/ccc?key=0AvTqJBK5ZdjNdFRCV0Uxd3RZOXdVMTVtWmt2dDJSMHc#gid=0

----------------------------------------------------------------------------------------------
following is a solution based on my understanding of the problem