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).
**Download file: bit.ly/3nSZT8l
--------------------------------------------------------------------------------------------------------------------------
00:00 Intro
00:25 Lookup & Return Multiple Values in a Single Cell
04:05 Lookup & Return Multiple Values (without repetitions)
--------------------------------------------------------------------------------------------------------------------------
☕ If you find my Excel videos useful and would like to support me, you can buy me a coffee - www.buymeacoffee.com/SumitB
✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/
✅ Free Dashboard Course - bit.ly/free-excel-dashboard-c...
✅ Free VBA course - bit.ly/excel-vba-course
✅ Free Power Query Course - bit.ly/power-query-course
✅ Best Excel Books: trumpexcel.com/best-excel-books/
Subscribe to get awesome Excel Tips every week: kzread.info...
#Excel #ExcelTips #ExcelTutorial
Пікірлер: 423
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! 😊👍
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...
Appreciate your generosity as usual by sharing such gem of knowledge and information to the public.
This is an awesome set of formulas for cleaning up your data and presenting it in a concise way, thank you for sharing!
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!)
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.
Straight to the point. TY. Was getting frustrated with all the other excel videos out there.
awesome!! my issue was exactly similar and it helped me perform better in finishing up the tedious task of 2-3 hours in just one go. love you man!
Very powerful and to the point, as always. Great Summit!! Thank you.
You just helped a whole team! Thanks a lot for sharing this video! :)
Another gem! Thank you!
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
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.
Thank you. This was so easy to follow compared to other tutorials I watched previously.
I bookmarked this video and today save my day at work. Thanks... again and again
Your tricks and teaching styles both are amazing ❤️
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: ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course ✅ Free VBA course - bit.ly/excel-vba-course ✅ Free Power Query Course - bit.ly/power-query-course
Brilliant code! Nice!! Exactly what I’m looking for!!!
I have searched for hours for this exact solution, Thank you!
Incredibly good! thank you!
You don't know what Importance you have in our lives thanku😊👍
Was looking for this quite a while, thank you so much.
This worked perfectly! Thank you so much for sharing this approach.
Love this - saved me a bunch of time trying to get creative! Thanks again!
Excellent!!! Thank you for the unique formula!!!
AWWWW man! This is so sweet! WOW!
@trumpexcel
3 жыл бұрын
Glad you liked the video Oz... How's the Excel hash challenge coming along? I am pulling my hair trying to get a coherent solution ready
@lopher70
3 жыл бұрын
Very kind of you comment Oz, great exceler, even greater person
@keithau8159
3 жыл бұрын
Yes.Salute,salute and salute to my dearest ancient lost civilization God===Khilasa Temple,really Wonder of the world,craft from bed rock as hard as granite not sand stone or limestone.Masterpiece,masterpiece and masterpiece=famous 80's pop song and musics.
This is pretty good and you got one more subscriber on your channel. From long time I was searching how to return multiple value in one cell, thanks for sharing👍
EXCELlent video! Thanks!
Great, thank you. Could you reference the spill range for the training courses to save copying the formula down?
Exactly what I needed and great explanation
Great video! Thanks!
I was looking for this formula. Thank you and God bless.
This was amazing, thanks so much for sharing!
you just saved us soooo much time, thank you from Brazil
Perfect! Thank you!
Thank you so much. Really appreciate your videos.
Thank you so much!!!!! Your the best!
You have saves a few days of my life by providing this formula.
You are amazing- thank you so much.
Awesome, this did exactly what I needed and was explained well. Thank you!!!
A good replacement to lookup functions. thanks a ton!!
Awesome..I was looking for this only
Very useful... love it - thanks!
Super helpful. Thanks!
Fantastic! Saved my butt! Thank you!
Thanks for this. It helped me a lot to solve my problem in writing remarks in the school form that has two conditions in one cell. God bless you.
Thank you so much for sharing this. This will make my work easier from now on.
Excellent, Simply Amazing! This is exactly what I am looking for. Thank you very much for this video!!!👍👍👍
Excellent you are a saviour !!
Incredible excel tips!!!
Thank you so much! This was just what I needed!
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.
@WarriorsWay90
Жыл бұрын
Thank you so Much brother❤
Amazing, thank you so much! 😍
You are amazing and a life saver. Just saved me 2 hours of work. 😁
This is absolutely amazing. You never cease to impress :D
a great method in simplifying and explaining how formulas go accurate
Hi Man, really appreciate what are you doing You really save my time! keep up
Awesome! thanks so much for sharing
Best ever! Doesn't take much computational power as well!
Superb bro I subscribed you immediately after this. This is how I want videos to be clear, crisp, nothing extra only to the the point discussion.
Thank you , it helped me a lot
Thank you for this. Had been struck in this problem for a long time. Very helpful.
Thank you so much!this is so helpful.
Fantastic explanation - very clear
This is a lifesaver, thank you very much.
Thanks for making it simple. God Bless
Extra Ordinary, best ever formula giving us level upto programmer level thanks....
Thank you this helped me soo much!
Excellent was searching here and there for this multiple match and landed in your explaination worked so simple ... Thanks a lot keep posting more tips
That's the thing i want, great brother , thank you
Bless you SUMIT and thank you.
Thank you very much. So helpful.
A different way having very Useful Technique! Thanks a lot
Great Tip and Tutorial, thank you so much for sharing your knowledge
Excellent. Thanks so much.
Superb vid. Thank you - very useful!
Great stuff. Thanks
Thanks dude. You literally saved me.
Thank you so much I was wasting time trying to do this same exact thing and your video gave me quick and easy fix!
I found it very useful, Sumit. Good job!
Very good! Thanks so much
Nicely done. I use Excel everyday. I can see how this could be useful.
Awesome Man. God Bless you 🙏
Thank you very much my friend. Doing the Lord’s work
Great help, sir. Thanks.
Thank you so much. I used this on a data set of over 100k rows and it worked perfectly. (I'm still not sure if I 100% understand and follow along, but it worked).
Thank you so much for sharing this. Very useful to me.
Awsome! And Excellent!!!
Excellent... My search for a solution ended after seeing your video..Great ...keep it up
Thanks for sharing, this was very much helpful
thanks brother - I was searching for a solution throughout the internet !!!!!
Great tutorial! What if I want to enter unique number and I want to see that unique number gets the data where it's assigned. how can I do that? Example if I want.to type serial number of laptop and assigned.to user, I want to see that value where it assigned. Thanks
Mind-blowing !
Thanks. Very helpful
Very good video...thank you!
Sumit you are a life saver!!!
Great one! But what if I dont have Office 19 or 365? How would you (or suggest) to concatenate text for the first part of the video, but using "normal" Excel versions?
What a man what a man .....superr mind blowing big fan of you sir
Excellent!!
Excellent Thanks for the Info😃