Lookup & Return Multiple Values in One Cell in Excel (Easy Formula)

In this video, I will show you two simple formulas you can use to look up and return multiple values in a single cell in Excel (separated by comma).

And the formulas that I cover are not dedicated lookup formulas (such as VLOOKUP or XLOOKUP or INDEX/MATCH). These are simple IF formulas combined with a new TEXTJOIN function (TEXTJOIN is only available in Excel 2019 and Microsoft 365).

--------------------------------------------------------------------------------------------------------------------------
00:00 Intro
00:25 Lookup & Return Multiple Values in a Single Cell
04:05 Lookup & Return Multiple Values (without repetitions)
--------------------------------------------------------------------------------------------------------------------------

#Excel #ExcelTips #ExcelTutorial

[gvinodnair]

Appreciate your generosity as usual by sharing such gem of knowledge and information to the public.

[beckygonzalez]

I praise my God for using you to show me how to find and join multiple results. I had been trying for several days and had been unsuccessful. Your teaching method is clear and leads to results. May God bless you and may you see His hand working in your life today. Sincerely, Becky

[Cu_Ty_Pro]

Thanks man. Exactly what I needed. A tip for everyone that has a long list of things in a cell. Instead of just 1 or 2. And want to make a new line for each thing.
Instead of [ ", " ]=> replace with CHAR(10)
Select the cell, choose Merge and Center on the Alighment section. Then Wrap Text.
Everything should look good.

[frenan]

I bookmarked this video and today save my day at work. Thanks... again and again

[SubXaeroZA]

Brother you are a legend, thank you for this saved me days of struggle. Gave that man a Bells!!!!

[konather]

I have searched for hours for this exact solution, Thank you!

[q-breezy]

This is pretty good, you may want to change the use of "IF" to "Filter" as I think that will be a little more straightforward and will probably perform better over larger data sets. You could also use the "SORT" formula around the unique if you wanted things in alphabetical order.

[amjeth]

Excellent! I'm happy that my logic of developing complex formulas from simple formulas are the same used by an expert like you as well...

[vsyamprasad]

Really u r great... i used to watch regularly many videos on excel, but u r a person who explain things in the right way and right quantum with quality... tq bro...

[trumpexcel]

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what Excel topics you want me to cover in future videos.

Also, I have made all of my Excel courses available for free. You can check these out using the below links:

[rajeevgosavi]

Sumitji, Your tutorials are always very informative, innovative, still simple to understand. We really appreciate your skills. Last time also I commented and requested you to also put up a video on how to use power query in a given scenario.
Thanks in advance. Or if you have already put up such video, kindly share the reference. Thanks.

[vijayarjunwadkar]

Simply WOW! While we have many functions available which are good by themselves, putting them together in smart way to solve practical problems this easily, is just another thing! Great! Thanks for sharing, keep EXCELling! 😊👍

[adnanali]

Appreciate your insights. The best thing is that you don't beg for "subscribe".

Plz record videos in high volume as the volume is quite low. Thanks.

[deekshachauhan]

You don't know what Importance you have in our lives thanku😊👍

[MrJamesHWard]

You just solved a big problem for me. I think you're an excellent person for making this video for the world to learn about. Thank you so much.

[jennydrumm]

OMG! My mind is completely blown! This is genius! (Actually, I was first dumbfounded when you showed the UNIQUE formulas and stayed that way through the whole video. Thank you SO much!)

[MalikBabarHasan]

Extra Ordinary, best ever formula giving us level upto programmer level thanks....

[rhayes]

I was trying to find a way to match multiple entries to a unique identifier and this is exactly what I needed to know. Thank you.

[adityasharma]

Dude you are blowing my mind.

Usage and Unique and If was impressive enough...and you brought along the textjoin too. At first I thought...why aren't you using Concat formula ..but when I practiced myself..I realized that this text join is a great great enhancement to concat formula...

[adityaverma]

You have saves a few days of my life by providing this formula.