Lambda Output to multiple cells

[bassplr19]

I created a lambda function to look up the cost of a part and a different function to look up the weight of a part. I want to create a new lambda function that calls both functions and outputs the result across two cells, is that possible?
Gemini suggested this:

=LAMBDA(part,QTY,
LET(cost, COST(part, IF(ISOMITTED(QTY), 1, QTY)),
weight, WEIGHT(part, IF(ISOMITTED(QTY), 1, QTY)),
{cost, weight}))

But the name manager seems to fail on the {

 

[ExcelToDAX]

How about:

=LAMBDA(part,QTY,
LET(cost1, COST(part, IF(ISOMITTED(QTY), 1, QTY)),
weight1, WEIGHT(part, IF(ISOMITTED(QTY), 1, QTY)),
HSTACK(cost1,weight1)))

 

[bassplr19]

How about:

=LAMBDA(part,QTY,
LET(cost1, COST(part, IF(ISOMITTED(QTY), 1, QTY)),
weight1, WEIGHT(part, IF(ISOMITTED(QTY), 1, QTY)),
HSTACK(cost1,weight1)))

Nice, but it doesn't work IN a Table. It works outside the Table, but I get a #SPILL error inside. Any thoughts?

 

[Fluff]

You cannot use spill ranges in a Table, they simply don't work.

 

[bassplr19]

You cannot use spill ranges in a Table, they simply don't work.

Lame, thanks!