User Profile
chippedlens
Copper Contributor
Joined Nov 11, 2023
User Widgets
Recent Discussions
Re: Passing a Table as a variable (in a LAMBDA() function)
Ok, figured it out, use INDEX instead of INDIRECT. Here is an example that returns the data from a column in a table: =LAMBDA(TableAll,ColumnTitle,DROP(INDEX(TableAll,0,MATCH(ColumnTitle,INDEX(TableAll,1,0),0)),1,))(Table1[#All],"Cost") Found a useful discussion: https://superuser.com/questions/1713772/dynamic-table-name-in-excel-lambda-function-with-structured-references-without-i3.3KViews0likes0CommentsRe: Passing a Table as a variable (in a LAMBDA() function)
ColinJHarrison I'm trying to do the same thing, pass a table to a lambda function. But I would greatly prefer a solution without the use of INDIRECT as it slows calculations way down as it is volatile. (Calculates every time anything changes.) Anyone have a solution for passing a table to a lambda function that does not use INDIRECT?3.3KViews0likes1Comment
Recent Blog Articles
No content to show