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 to work. It seems to input the wrong cell references? 

​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 to work. It seems to input the wrong cell references?   Read More

​