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. :)*

*https://docs.google.com/*spreadsheet/ccc?key=0ArpmMlaQcWc6dDctNllQX2hibmVmR1g1d2F5UHpzM0E&usp=sharing

*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

```
```