yogi_Array Formula In Cell C37 Based On Values In Cells B37 To B With A Static Header Value In C37 and C38 (From Cell C36)

             Google Spreadsheet   Post  #1869

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-29-2014

post by  Raivis.:
https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/83OzEZ7iWwA
Array formula returns same value after refreshing the page

Hi,

I am completely lost on this one.

This is the formula ={"Trade";"Trade";ARRAYFORMULA(if(ISBLANK(B39:B),,VLOOKUP($B39:$B,'Work Scope Item List'!$A4:$N,column('Work Scope Item List'!C2),FALSE)))} entered in C37 and below you can see that after the page refresh it returns the same thing all over again.

BUT, for example, if I go to C44 and delete the contents, then the array formula refreshes with the correct result. Any suggestions?

-------------------------------------------------------------------------------------------------------------------------------------

to my knowledge what you are experiencing is not a bug in Google spreadsheet -- it is your formula in cell C37 (and D37:F37) that need fixing ...

presented in the following solution is one way to do what you are trying to accomplish -- note how I have altered your formula ever so slightly to make it do what you want