Allow users to define custom non-VBA functions from built in functions, this can be used to simplify complex functions that are used often e.g.
FastVlookup = (X, Y, Z) => IF(VLOOKUP(X,Y,1,TRUE)=X,VLOOKUP(X,Y,Z,TRUE),NA())9 votes
Good news! We have added support for native lambdas as of today in Insiders: Beta.
Please see this post for more details:
- Don't see your idea?