Forum Discussion
gjvdkamp
Jul 27, 2023Copper Contributor
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 ...
Patrick2788
Jul 28, 2023Silver Contributor
You have 2 arrays, each with 2 elements in your MAP.
MAP's return array can only be 2 elements. You'd have to use MAKEARRAY to return the 2x2 array.
Additionally, you could use:
=A2:A3+B1:C1