7 Replies Latest reply on Jun 17, 2016 7:53 AM by Tom W

    Using non-aggregated data from different sources in calculated field (VLOOKUP function)

    Ibiaçu Caetano

      Hi! I wanna match the cost of a transaction through 2 different data sources.

       

      In my attachment, I uploaded two excel files to the workbook. One file has the transaction numbers and the other has transaction numbers and the related cost. I'd like to create a column in the first data source and call the related costs from the second data source. So it's basically a row level function that should match each transaction with the second data source and bring the related cost.

       

      Is it possible?