Forum Discussion
Adding spill to an xlookup with an array result only returns first result
Hi all, I have a situation where I need to lookup a range in a table on a spill reference, and that range needs to be dynamic. I can take the below formula to get my range to do my lookup ag...
Perhaps
with
=IFERROR(FILTER($B$6:$K$7,IFNA(XMATCH(A6:A7,A1#),)),"nothing")if sorting order is not important