Forum Discussion
expand a dynamic named range
I work in insurance. I am building a template that can work with our customers who have a random number of health plan options (possibly more than one each of: health plan, dental plan, vision plan...
BillY2305 Another option for performing a basic cross join of two vectors is as follows:
=LET(
arr, LAMBDA(n, TOCOL(CHOOSE(n, Plans, TOROW(Options)))),
HSTACK(arr({1}), arr({2}))
)
Sample Results
See attached, if needed...
