Is it possible to, say, maintain a database in separate workbook. Then create a UDF that will just pick data from that database based on certain parameters defined in the UDF like YEAR, Account, Entity?
For example, I have all financial data in the database from year 2000-2006. If I use the UDF, say =specialfunction(2005,110000,Company1), then it will just return the corresponding value from the database?
I am just asking if this is possible in excel and if so, just a broad idea of how difficult is it to set up.
Thanks.
For example, I have all financial data in the database from year 2000-2006. If I use the UDF, say =specialfunction(2005,110000,Company1), then it will just return the corresponding value from the database?
I am just asking if this is possible in excel and if so, just a broad idea of how difficult is it to set up.
Thanks.