Forum Discussion
Solved
I need some help with a help vlookup. I need to return several matches into the same cell
how can I get several results from a vlookup into one cell? NOt only the first one.
When it shall be very small icon at the bottom left of the Reply
15 Replies
With more traditional functionality
formula is
=TEXTJOIN(", ",1,IF($B$2:$B$10=$E$3,$C$2:$C$10,""))I tried, but I do not have the formula "FILTER", it is bring me only the date for the first row and it is not following the key cell, the one I want it to look for.
this is my formula:
=TEXTJOIN("; ",TRUE,summary!P:P,summary!D:D=Sheet5!D4)
You may not be on the 365 Monthly update channel. If you're 365 Semi-Annual then you'd get it in July.
