Forum Discussion

gjvdkamp's avatar
gjvdkamp
Copper Contributor
Jul 27, 2023

Use MAP function on perpendicular ranges

If I use the formula (notice the B1:C1 horizontal and the A2:A3 vertical range, both have [1,2] values)   =MAP(B1:C1,A2:A3,LAMBDA(a,b,a+b))   I would expect  2   3 3   4   But I get  2      ...

Resources