Hi
I'm using UDF MLOOKUP form
http://www.excelfox.com/forum/f12/vl...iple-values-4/
Basically this is the the same function as lookup, but it returns multiple results in one cell.
I have 2 sheets, where MLOOKUP is used multiple times to construct the reports. But it takes too much time and I had to turn off AutoCalculation on these sheets as the whole Workbook becomes very laggy. An when I turn it on again, it could take more than minute to calculate the results. As my database will become tens of times larger, I am thinking of ways to optimise it.
Could you please advice me other approaches.
Many thanks.
P.S. Here is the code of this UDF.
![]()
Please Login or Register to view this content.
Bookmarks