Forum Discussion
GEM012178
Feb 21, 2020Copper Contributor
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.
- Feb 21, 2020
When it shall be very small icon at the bottom left of the Reply
SergeiBaklan
Feb 21, 2020Diamond Contributor
With more traditional functionality
formula is
=TEXTJOIN(", ",1,IF($B$2:$B$10=$E$3,$C$2:$C$10,""))