SPILL Results across and down for XLOOKUP (and Small Function)

[willbaggs]

Any ideas on how to get spilled results across and down for the following?

I'm using SMALL function to find the 3 smallest values for each person. I can only get it to spill across or down - is there a way to get it to spill across and down?

 

[Fluff]

Duplicate to: XLOOKUP within LAMBDA BYCOL

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.