I have a formula that somehow causes excel to crash and am wondering if anyone knows why.  This formula returns the value of (let’s say) 1.  It is a one and can be used as a one in some cases.  However, as soon as I put the “grp” value into an index function or do math on it within the module editor, excel crashes (it actually crashes on save in the module editor).  

​I have a formula that somehow causes excel to crash and am wondering if anyone knows why.  This formula returns the value of (let’s say) 1.  It is a one and can be used as a one in some cases.  However, as soon as I put the “grp” value into an index function or do math on it within the module editor, excel crashes (it actually crashes on save in the module editor).   groups.getGroupID = lambda(grps, group_name,    let(        grps_names, unstuff(grps(1)),        grp, match(group_name, grps_names, 0),        grp    )); For example, this returns the value of 2:=INDEX(LET(grps,groups.create(groups.createArgs(tbl_colors,2)),groups.getGroupID(grps, “red”)),1,1) This returns a value of 3: =INDEX(LET(grps,groups.create(groups.createArgs(tbl_colors,2)),groups.getGroupID(grps, “red”)),1,1)+1This crashes excel:groups.getGroupID = lambda(grps, group_name,    let(        grps_names, unstuff(grps(1)),        grp, index(match(group_name, grps_names, 0),1,1),        grp    )); and this crashes excel: groups.getGroupID = lambda(grps, group_name,    let(        grps_names, unstuff(grps(1)),        grp, match(group_name, grps_names, 0) + 1,        grp    ));   Read More

​