Trying to pair EACH element of A1:A4 with EACH element of B1:B4 to create a new data set of all combinations. Desired results in D1:E16.
Seems like a good candidate for LAMBDA, BYROW, and/or maybe MAP but just can't seem to get there! Even tried PERMUT but no luck.
Am I overcomplicating it or is it just not doable??? Prefer to not use VBA.
Would need to allow for different "sizes" between the two arrays as well.
Using Windows 10, Excel 365.
Thanks!
Seems like a good candidate for LAMBDA, BYROW, and/or maybe MAP but just can't seem to get there! Even tried PERMUT but no luck.
Am I overcomplicating it or is it just not doable??? Prefer to not use VBA.
Would need to allow for different "sizes" between the two arrays as well.
Using Windows 10, Excel 365.
Thanks!