Forum Discussion

Lopezr2307's avatar
Lopezr2307
Copper Contributor
Oct 06, 2021

TEXTJOIN and IF and MATCH

So a little bit of background, I am using the TEXTJOIN and IF statement to pull multiple values from one tab and pull them into one cell on a tab. This works and the values are pulled in the problem ...
excel
Formulas and Functions
  • Lopezr2307's avatar
    Lopezr2307
    Copper Contributor
    Oct 06, 2021
    That is the thread I have been following and the video that I was using, the problem is that it does not incorporate the lookup function as well.. I need to be able to perform the if a = b then give me c, then sort through all the c's and only return unique values
    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Oct 06, 2021

      Lopezr2307 

      You may try

      with array formula

      =TEXTJOIN(", ", 1,
  IF( COUNTIF(A2,B2:B28)*
     ( MATCH(C2:C28,C2:C28,0) = (ROW(C2:C28)-ROW($C$1)) ),
     INDEX( C2:C28, ROW(C2:C28)-ROW($C$1) ),
   "") )

Resources