Forum Discussion

n-v-l's avatar
n-v-l
Copper Contributor
Nov 26, 2019
Solved

TEXTJOIN with and IF and extra VLOOKUP

Hi, I'm trying to figure out if what I'm trying is possible at all or if I should try a different approach.   In short my issue: I managed to create a TEXTJOIN formula with an IF that produces id...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 26, 2019

n-v-l 

To imitate your model

current formula in H2 is

=TEXTJOIN(";",TRUE,IF(A:A=$G$2,B:B,""))

and modification to return names

=TEXTJOIN("; ",TRUE,IF(A:A=$G$2,IFNA(VLOOKUP(B:B,D:E,2,FALSE),""),""))

Not very good from performance point of view, better to use with dynamic ranges.

n-v-l's avatar
n-v-l
Copper Contributor
Nov 27, 2019

Hi SergeiBaklan ,

 

Thank you very much for the example.

I carefully tried to copy it into my "real" formula (first tab column E) and checked double for typo's but get a blank result.

Can you spot where I made a mistake / thinking error ?

I have attached a slimmed down version of my file I use.

When I test the lookup separate it returns a value, after that I didn't know what else to test for.

 

Thanks,

Nico

    • n-v-l's avatar
      n-v-l
      Copper Contributor
      Nov 27, 2019

      SergeiBaklan  thank you very much.

      So it was an issue with the naming.

      As it is very often... it's right in front of you 🙂

       

      Thanks again, I will play a bit to understand it better so maybe I can help somebody else in the future.

       

      Nico

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Nov 27, 2019

        n-v-l , your are welcome. Post here if any questions regarding the formula.

Resources