Search code examples
google-sheetsnestedmatchgoogle-sheets-formulatextjoin

Nesting formulas not working as expected Google Sheets

I am trying to nest the following two formulas, both work.

cell AO2 = Bob, cell AP2 = Judy

=TEXTJOIN(\"|\", True, AO2, AP2) = Bob|Judy

=SUBSTITUTE(ADDRESS(1,MATCH("*sumAppTags",Elements!A1:BB1,0),4),1,"") = Column Index AO

If I try:

=TEXTJOIN("|", True, SUBSTITUTE(ADDRESS(1,MATCH("*sumAppTags",Elements!A1:BB1,0),4),1,"")&2, AP2)

I get: AO2|Judy

Is there a way to get this to work?

Solution

  • try:

    =TEXTJOIN("|", 1, INDIRECT(SUBSTITUTE(ADDRESS(1, 
 MATCH("*sumAppTags", Elements!A1:BB1, 0), 4), 1, )&2), AP2)