Friday, February 18, 2011

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


No comments:

Post a Comment