2 Replies Latest reply: Jul 3, 2017 2:52 AM by Andrey Khoronenko RSS

    Aggregating data from specific clients in associated databases

    Alvaro Tarzona

      Dear all,

       

      First, apologies if this has been asked before. I am attaching a file that has 3 sheets that explain my problem. I have three databases, and I need to aggregate data for specific clients using data from 2 databases (assets in one, and liabilities in another). Using the client database (or sheet in the Excel) I want to look for specific client ID in the other 2 databases and add their respective amount of assets and liabilities. Not all clients have assets data and not all have liability data as you can see.

       

      How can I complete column D in the Client Sheet? Do I need to code?

       

      Thank you very much for your help.

       

      Best regards,

       

      Alvaro