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
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.

      • n-v-l's avatar
        n-v-l
        Copper Contributor
        Dec 01, 2019

        SergeiBaklan  a small question about something I noticed when I updated the formula on my local PC.

        All the values suddenly are the same (picname1.jpg). Could this be an issue with my excel/office365 version as far as you know?

Resources