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:

https://productforums.google.com/forum/#!topic/docs/W_Z93vbbo3w;context-place=forum/docs
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.

Edited