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.
Bookmarks