Xlookup return array problem.

Hi

See the attached Book1 with Xlookup functions in D19 & D 22 referencing the range C5:F14 and looking up ID in C19:C20 (1st Scenario) and C22 (2nd Scenario).
I use range ID - C6:C14: to select some of the ID's (more than 1) as I did in D19 and expect an array with the #yield, #spread and #duration in a 2*3 array of the selected ID', the function only return a 2*1 array with #yield data. In D22 I select only 1 ID which is returning a 1*3 array.
Why does both xlookup's not return x*3 arrays in both, the return array's of the xlookup function in both functions are the full 9*3 array?

Thanks for the help in advance.

The xlookup function will only return a 1d array, not a 2d array, however you could use index/match

Formula:

Please Login or Register  to view this content.

This is perfect, thanks

You're welcome & thanks for the feedback