Tuesday, June 25, 2013

yogi_Query Data based On Header Names in Row 1 Of Summary Sheet

                                          Google Spreadsheet   Post  #1261
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jun 25, 2013
user Tor Cunningham (http://productforums.google.com/forum/?zx=ksirz5o3le8l#!category-topic/docs/spreadsheets/NRDcG9PYcCw)
Query data based on header names
I have a large array of data in one sheet which I want to summarize in a second sheet.

I need a formula to bring across data depending what header is in the first row.

So in the example sheet linked below I would like to insert a formula in Summary!A2 that will bring through data for all three columns that have the same header in the corresponding data sheet no matter what order they are in.

I have previously just used a formula in each column but now have many data sheets that have header names in different places and it makes merging the data difficult.

sample sheet link:

thanks in advance for any help