Tuesday, April 9, 2013

yogi_Pull Data From Select Columns Of Student Roster For A Specified Student

                                          Google Spreadsheet   Post  #1102
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr 9, 2013
user BeeCon :(http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/RJysoNHjelk)
Convert a keyword search macro into workable script
Hi guys, I am keeping at this. I've swtiched from macros/scripts to functions. I could really use some help writing this as I think its too advanced for me.
I have tried: VLOOKUP, QUERY, FILTER functions which I can't get to work.

I have created a sheet with fake data to express what I want to do with expected results.
Heres a link:

there are many hidden columns which on the real sheet will also have data I would like copied to my 'Expected Results' section. I have hidden these columns for simplicity.

Any ideas?

following is a solution to the problem