TEXTJOIN Function, Like VLOOKUP with Multiple Matches - Google Sheets Tutorial, IF, TEXTJOIN, Arrays

Learn how to use TEXTJOIN Function to return multiple matching results, which is something you wouldn't be able to do using VLOOKUP function.

TEXTJOIN VLOOKUP replacement

Google Sheets

[AlexRecks]

Man, I was struggling all day at work trying to find this exact solution. Thank you so much!

[kennethforbin]

This guy is a savior, i wish i can connect with him on Linkdeln or some place

[oebuudw]

You are the best on Explanation.
I want to work with you every day.

[melaniecroskrey]

Thank you!!! This is what I've been searching for for weeks! Very easy to understand and sharing the example spreadsheet was SO helpful.

[marliestusch]

This is exactly what I was looking for! Great video, simple explanation - everything works perfectly!

[asiaboba]

I like all your lessons, even most of the time I already learned it before I play the videos, but I will still paying full attention on every things you teach me, and often repeatly watching your videos, because you always dive in every parts of your lesson very detail, let me found that I missed out a lot of easy functions which can let my job become much more easier and simple, really thanks for your tutorials, and thanks for teaching me all the skill and knowledge to strengthen my base in my programming studies, and I know all your students also loves the way you teaching and enjoy your lessons too, because the number of your students keep increasing time by time, keep up your good work, and I will always keep watching your tutorials for revisions...
Little comment for you regarding the tutorial of this video: If there are multiple matches, I think it will be easier by using the filter function instead of vlookup function, and the solution will be
Southern | =TEXTJOIN(“”, TRUE, FILTER(D:D, B:B=F7))

[KristyCha]

All I was missing was the Array--why isn't that called out on the other 5000 articles I wasted my time on? Thank SUSCRIBED

[takaakiyamada]

I had no idea that we could do multiple matches with Google Spreadsheet. Thank you! :-)

[msangelinejoe]

Wow it works with =arrayformula(textjoin)
Thank you so very much for your help! Much love ❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️

[eugeneestella]

wow, it really works, you solve my problem, I have been looking for this solution..Thank you

[cococa]

Thanks for the video, it helped. What happens if you get duplicates in your answers? How do you get rid of them?

[shinhoyoung]

Hi I have only one question.
I used "arrayformula function" to auto-fill values from second row to end row.

If I don't want to drag down the "G7" function, How can i?

e.g)
region | Sales Rep
Southern |
Midwestern | auto-fill result

+ how can i textjoin using "\n" in this case?

[ericdwenger]

What is the formula if I'm trying to look through multiple sheets and compile all the data from multiple sheets into one cell with a line break?

[mdrumi]

Sir, as some new function has been added into Google Sheets, is there any work around for using Arrayformula with Textjoin or Index function to get rid of the dragging formula down like the case in this video?

[alvesval]

Awesome video! perfect example. I have one question, though. Let's say for example 'Southern' and 'Paul Patrick are listed twice in multiple rows. The result would show 'Paul Patrick' as many times it appears in Column D, where Column B='Southern'. How to avoid this duplicate result and show 'Paul Patrick' only once in G7?

[dennis.teevee]

awesome! would definitely help me w/ my project!

[yjs]

Thank you so much, can we add one more condition?

[kennethngai]

what formula would you use, if you have 2 creteria? let say you want the TextJoin southern region in year 2015 only?

[moheuddin_sehab]

damn.. you are so good at it
3 question
how many years did it take you to know this much?
how many years have you been using spreedsheet?
and how much do you earn? annually!

[Ofer.Sheinberg]

In what situation will this IF statement be preferable to using FILTER, i.e. simplifying it to =TextJoin(", ", True, Filter(D:D, B:B=F7)) ?