4 Replies Latest reply: Sep 28, 2017 3:04 PM by Alvaro Tarazona 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,