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:
https://docs.google.com/a/watertown.k12.ma.us/spreadsheet/ccc?key=0AhElu_CbtWnFdFlmRmVSUS1VaWw2RDlmQ2dqTW9Qb3c#gid=0

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?
BRIZZLE!!!

-----------------------------------------------------------------------------------------------------------------------------
following is a solution to the problem