Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Aug, 3 2013
user Tim Brehaut (http://productforums.google.com/forum/?zx=t4pky2oc4l45#!category-topic/docs/spreadsheets/G6dIXDBPdzk)
Arrayformula/Query not working as desired
I'm trying to summarize data from Sheet2 into Sheet1. Sheet2 is populated from Form submissions and includes names in column B, months in column D, and a score in column T. On Sheet 1 I would like to create a formula to check the name in column A (to the left) and the month in row 3 (above) and return the highest matching score from column T. I've tried both Query and ArrayFormula but can't quite get it to work.