This content has been marked as final. Show 2 replies
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.