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

Resources