13 Replies Latest reply: Sep 12, 2014 5:14 AM by Miikka Koskinen RSS

    When to apply lookup on concatenate table

    Drew Lees

      I am wondering at what point should I apply lookup formula on a concatenated table?

       

      I have two tables, one containing call information, one containing email information.

       

      I want to apply a lookup on the phone number and the email address so that a name appears in one column. How would I go about doing this? Do I need to concatenate the tables and then apply the lookup or apply the look up separately to both tables and then concatenate?

       

      Thanks,

       

      Drew