Forum Discussion
Lambda
I used this Lambda function: "=LAMBDA(range,IFERROR(TOCOL(FILTER('3 times'!K3:CL3,(range=3))),""))(K4:CL4)" and it worked perfectly. I then inserted it into name manger, created a name and it fails...
You use relative reference within the formula. Let say you stay in A1 and add above formula in Name Manager. Within formula it'll be '3 times'!K3:CL3
Now stay on any other cell, let say A3 and check the formula. Now you see within it '3 times'!K5:CL5
Not sure what exactly you'd like to do, if '3 times'!K3:CL3 shall not be changed perhaps use the name for this range.
- thank you. got it!
