Forum Discussion

Copper Contributor

Mar 06, 2020

Trying to figure out formula

Before typing out my problem thanks for taking a moment to help. I am trying to figure out what formula needs to be used in order to populate and combine data from multiple cells into one. Say ...

Formulas and Functions

SergeiBaklan

Diamond Contributor

Mar 06, 2020

Someone1

Your formula also works if use it as

=CONCATENATE(
  IF(ISNUMBER(SEARCH("x",D3)),$D$1,"")," ",
  IF(ISNUMBER(SEARCH("x",E3)),$E$1,"")," ",
  IF(ISNUMBER(SEARCH("x",F3)),$F$1,"")
)