Hi
I want to ask user to enter date then excel will return the average of temp1 and temp2 (reverse look up + array). My formula is this
=AVERAGE(INDEX(A2:C7,MATCH(F1,C2:C7,0),{1,2}))
(ctr+shift+enter)
but for the date 4/22/16 , excel returned 35 ! I was expecting (35+33)/2 instead. So excel...