Saturday, December 28, 2013

yogi_Pull Header (From Row 1) Where Multiple Criteria Intersect

                                          Google Spreadsheet   Post  #1457
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Dec-28, 2013
question by R.Todd (!category-topic/docs/spreadsheets/kG8WxBkElh8)
Return Column Header w/ Multi Criteria
I'm trying to find a way to return the column header for a row matching multiple criteria in Google Spreadsheet. I've been able to successfully use INDEX MATCH to return the header for a single variable, but when I add in the second one, I can't find how to get it to return the column header for the second variable only.
In the mockup included above, A2:A4 contains criteria 1, while B2:F4 contains criteria 2. I need to return the column header(s) for the row that meets both criteria at the intersection(s) of the column(s) crossing criteria 2. I've tried various attempts with INDEX MATCH and QUERY (of which I'm not great) and haven't been able to get anything. My preference is to keep this to FORMULAE, but any input would help.
Any thoughts? Eventually the final dataset will include multiple worksheets using indirect references, but I just need to get this first component functional