Friday, February 18, 2011


Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  

taffypaul said
Search row2 for text and return the contents of the cells below (and their next adjacent ones) without changing the structure of the data.

for example:
search for "feb" should return the following result...

ef,  gh
dd,  ee
I used MATCH function to search the column number for feb, and then the QUERY function to pull the rest of the information of interest