I've just learned about the LAMBDA function, but am not sure how to use it. I've attached a workbook which uses VLOOKUP with nested INDIRECT formulas, and want to see if I can speed up the workbook if I change over to LAMBDA.
(this is a multi-sheet workbook with about 2 million cells).
If its easier for you, here's an example of my current formula, which is used about 10,000 times in this workbook:
Thanks for your help!
Please Login or Register to view this content.
The VLOOKUP formula returns a #REF! error in your sample workbook.
Why would you upload a sample WB that does not have all sample info/data of what you are working with?
What/where is SOLR?
Please also provide more than just 1 sample row of data, and show expected outcomes
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks