Tuesday, March 14, 2017

yogi_Pull Data From Cells In Another Sheet And Join With Data In The Current Sheet

Google Spreadsheet   Post  #2129
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Mar-14-2017
question by tony.silviera:
this is the last formula that is giving me problems
thank you to all that have helped me on this journey to get this darn sheet up and running!  this is the last of the problems...

=textjoin("--",1,INDIRECT("dpn-" &$C$2& "!BA6"),(AE6))

this works, but when i try and copy this down the column, the BA6 remains static but the AE6 updates properly (AE7, AE8, etc.)

now i think it is because I have the "!BA6" in quotations but I have tried removing them, replacing with single quotes, replacing with parenthesize, all of which break it.