Monday, December 29, 2014

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   Dec-29-2014
post by  Raivis.:!category-topic/docs/spreadsheets/83OzEZ7iWwA
Array formula returns same value after refreshing the page

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

No comments:

Post a Comment