Forum Discussion
Returning Multiple lines with the same reference (XLOOKUP)? For a quotation look up document
Hi All, I have been struggling with this for some time and cant quite seem to get over this hump. I am trying to build a quotation spreadsheet to rapidly increase what is done manually by c...
I tabled your two ranges and used a formula:
=REDUCE(
Header,
UNIQUE(Requests[Requested Work TASK CODE]),
LAMBDA(a, v,
LET(
filtered, FILTER(TaskData, TaskData[Task Code] = v, v),
VSTACK(a, EXPAND(filtered, , 10, "Not Found"))
)
)
)
Thanks Patrick, this works and I think its REALLY close to what I'm after!
I might be being thick here, but if I add more tasks to the requested list (lets say it goes from 7 task lines to 70, could go up to a couple of hundred) the return box still only shows the original number of lines. I can't drag the box larger, and cant see a number of rows in the formula. Maybe I am missing something obvious - How can I make the number of returns larger?
Thanks again, really helpful!
I might be being thick here, but if I add more tasks to the requested list (lets say it goes from 7 task lines to 70, could go up to a couple of hundred) the return box still only shows the original number of lines. I can't drag the box larger, and cant see a number of rows in the formula. Maybe I am missing something obvious - How can I make the number of returns larger?
Thanks again, really helpful!