yogi_SearchRowForTextAndReturnContentsBelow

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

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
st,
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