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   May 04, 2013
user StudentSupport (!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:

following is a solution based on my understanding of the problem