3 Replies Latest reply on Jun 6, 2018 5:39 AM by Sohan Jawar

    Join data based on multiple columns in one data set and a single column in the other

    Jos Reijers



      I'm working with excel files and I have an issue joining them. The first data set I have is structured as follows


      Start Date     End Date      Email1     Email2     Email3     Email4     Email5


      The second dataset is


      Number      Email


      This issue is that the join must be done on either of the 5 columns in data set 1. So an e-mail address in the second data set could match on of the five in random order.


      I saw a solution with a join 1=1 and then a calcuated filter but that doesn't seem to work or I'm missing the point there.


      Any help is welcome!