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

      Hi,

       

      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!

       

      jos