Tuesday, April 30, 2013

yogi_Value In Column B For Latest Date In Column A For Specified Month -- WorkAround For LookUp Function In Excel

                                          Google Spreadsheet   Post  #1163
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Apr 29, 2013
user Malbec159  (http://productforums.google.com/forum/?zx=crpyw0e3sdva#!category-topic/docs/spreadsheets/aNrTUWn8vgI)
IFERROR formula imported from excel does not work in Gdocs
I have a formula that works fine in Excel, but when I import that excel spreadsheet to Gdocs, the formula doesn't work. I have attached the original excel spreadsheet, and the below is the gdocs spreadsheet link. Any help to make this work in GDocs would be appreciated. :) 

This is the formula that works in excel, but not in Gdocs:
=IFERROR(LOOKUP(2,1/((MONTH($A$1:$A$366)=MONTH("1 "&D1))*($B$1:$B$366<>"")),$B$1:$B$366),"")
following is a solution to the problem