No video :(

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

Подписаться 375 тыс.

Просмотров 550 тыс.

50% 1

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: ru-vid.com...
#Excel #ExcelTips #ExcelTutorial

Опубликовано:

7 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 430

@vijayarjunwadkar 3 года назад

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! 😊👍

@amjeth 3 года назад

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...

@gvinodnair 3 года назад

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

@jennydrumm7223 3 года назад

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!)

@beckygonzalez5269 2 года назад

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

@MrJamesHWard 2 года назад

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.

@HowToAnalyst 2 года назад

This is an awesome set of formulas for cleaning up your data and presenting it in a concise way, thank you for sharing!

@piyushakushwaha 2 года назад

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!

@wantsoobaroo 2 года назад

Straight to the point. TY. Was getting frustrated with all the other excel videos out there.

@rhayes3281 2 года назад

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.

@Cu_Ty_Pro 2 года назад

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❤

@IvanCortinas_ES 3 года назад

Very powerful and to the point, as always. Great Summit!! Thank you.

@frenan82 8 месяцев назад

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

@DessyBlueberryCards 3 года назад

You just helped a whole team! Thanks a lot for sharing this video! :)

@christina9148 Год назад

Thank you. This was so easy to follow compared to other tutorials I watched previously.

@anilrungta4664 3 года назад

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.

@jhadsnju 2 года назад

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👍

@deekshachauhan8338 3 года назад

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

@joter-rificteacher8360 2 года назад

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.

@theoffsideartist 3 года назад

Your tricks and teaching styles both are amazing ❤️

@konather8065 Год назад

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

@ravisankarganesan9767 Год назад

Excellent, Simply Amazing! This is exactly what I am looking for. Thank you very much for this video!!!👍👍👍

@adityaverma7297 Год назад

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

@Ryan06505 2 года назад

Love this - saved me a bunch of time trying to get creative! Thanks again!

@yelagiriramcottagevenkatav9100 2 года назад

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

@jusjerm 2 года назад

This worked perfectly! Thank you so much for sharing this approach.

@Ja5pr33t 3 года назад

You are amazing and a life saver. Just saved me 2 hours of work. 😁

@ahmedaiad3372 Год назад

a great method in simplifying and explaining how formulas go accurate

@edwardjacobe4834 2 года назад

I was looking for this formula. Thank you and God bless.

@rishavjoshi4293 Год назад

Was looking for this quite a while, thank you so much.

@josesmagalhaes 3 года назад

Thank you so much for sharing this. This will make my work easier from now on.

@oOomadboyoOO Год назад

you just saved us soooo much time, thank you from Brazil

@Stevie74133 2 года назад

Thank you so much I was wasting time trying to do this same exact thing and your video gave me quick and easy fix!

@michaellau624 2 года назад

Hi Man, really appreciate what are you doing You really save my time! keep up

@souravchauhan7631 Год назад

Thank you for this. Had been struck in this problem for a long time. Very helpful.

@keilo338 2 года назад

Brilliant code! Nice!! Exactly what I’m looking for!!!

@npc2856 2 года назад

This is absolutely amazing. You never cease to impress :D

@stevereed5776 3 года назад

Great, thank you. Could you reference the spill range for the training courses to save copying the formula down?

@MaximumPasta Год назад

Awesome, this did exactly what I needed and was explained well. Thank you!!!

@Studyinginhu Год назад

Incredibly good! thank you!

@krnaveengupta Год назад

Excellent... My search for a solution ended after seeing your video..Great ...keep it up

@vsyamprasad 3 года назад

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 3 года назад

Glad you're finding the videos useful!

@pfatalbert Год назад

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).

@romcorleone Год назад

Thank you very much my friend. Doing the Lord’s work

@MalikBabarHasan60855 6 месяцев назад

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

@YouExcelTutorials 3 года назад

I found it very useful, Sumit. Good job!

@carlosmartinezreborned6403 2 года назад

Great Tip and Tutorial, thank you so much for sharing your knowledge

@padmalbert 3 года назад

A good replacement to lookup functions. thanks a ton!!

@LuisFernando-yd3mx 3 года назад

Nicely done. I use Excel everyday. I can see how this could be useful.

@larifari7473 3 года назад

Excellent!!! Thank you for the unique formula!!!

@shikharbudhiraja7686 3 года назад

Best ever! Doesn't take much computational power as well!

@Mayurbhoir05 2 года назад

Awesome..I was looking for this only

@aminadam3362 Год назад

Great video, thanks. Please note that if any of the values within your referenced range contains #N/A error, the output of this formula also throws up the #N/A error.

@trumpexcel 3 года назад

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

@piotrpp5478 11 месяцев назад

Fantastic! Saved my butt! Thank you!

@GiSStation Год назад

That's the thing i want, great brother , thank you

@ollimatik Год назад

Very useful... love it - thanks!

@muhammadnazar2978 3 года назад

A different way having very Useful Technique! Thanks a lot

@leonrobinson2053 3 месяца назад

Exactly what I needed and great explanation

@thejus2255 Год назад

thanks brother - I was searching for a solution throughout the internet !!!!!

@mrmusicloverable 3 года назад

Another gem! Thank you!

@anthonyfisiihoi Год назад

EXCELlent video! Thanks!

@bharatarse1503 2 года назад

Wow really amazing. I will going to use it. Keep sharing excel tricks.

@q-breezy4826 3 года назад

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.

@MohammedRafee-yz1oo Год назад

this may cause data overwrite.

@ahmedalhady4028 7 месяцев назад

"Filter" won't bring the data in one cell

@q-breezy4826 7 месяцев назад

@@MohammedRafee-yz1oo I mean to replace the if formula which returns an array in this example with the filter formula that also returns array, in both instances a formula like text join will convert the array into a delimited string. Either works just fine, I just find the use of the filter formula a little simpler/easier to read/explain than the if. If some condition is true with this range return another range otherwise return nothing, vs filter all the values I want where my condition is true. For people that don't do formulas/logical conditions as much it's just a tad harder wrapping your head embedded if statements, however in this example they are both pretty close so either way is fine.

@q-breezy4826 7 месяцев назад

@@ahmedalhady4028 replied in another thread.

@swindonbob 9 месяцев назад

Fantastic explanation - very clear

@rajeevgosavi4514 Год назад

Excellent. Pretty good way to use nested functions. Would be very obliged if you show how power query shall be used in this case.

@LeonardoRojasEliassen Год назад

Thank you so much!!!!! Your the best!

@sarahroberts7499 2 года назад

Thank you so much! This was just what I needed!

@nasma.e7440 Год назад

Amazing, thank you so much! 😍

@blc2102 3 года назад

This was amazing, thanks so much for sharing!

@adityasharma0101 3 года назад

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...

@trumpexcel 3 года назад

Thanks for commenting Aditya... Glad you found the video useful :

@cacapsule1727 Год назад

What a man what a man .....superr mind blowing big fan of you sir

@poojasainkar1458 2 года назад

Excellent you are a saviour !!

@stephengaldo2690 Год назад

Thanks for making it simple. God Bless

@NevilleVakharia1 Год назад

Super helpful. Thanks!

@nazarkamal8831 7 месяцев назад

Thanks a lot this is what exactly i am looking for long days 👍👍👍👍👍👍

@mariabc9815 3 года назад

Thank you so much. Really appreciate your videos.

@alinedesouza4427 2 года назад

Awesome! thanks so much for sharing

@christinebracken6865 3 года назад

You are amazing- thank you so much.

@shrimaanlalitsingh1870 2 года назад

Surely i am going to watch your all videos😁

@mia5134 Год назад

This is a lifesaver, thank you very much.

@tinaotchere 2 года назад

Thank you this helped me soo much!

@sudhakarjain1299 2 года назад

So easy you explain, it is quite an easy to learn

@saravanananamalai1114 2 года назад

Bless you SUMIT and thank you.

@harikrishnanselvaraj1732 2 года назад

There are many times scratching my head to do this. This is really handy.

@naingtun6620 2 года назад

Thank a lot ,I want to know this function for a long time

@excelemployeeleavetracker1274 Год назад

Very good video...thank you!

@hcholdsworth9936 3 года назад

Great solution but, just an idea, if you’re using 365 then you could also use the filter function instead of if... result is the same though so your choice!

@dayanandsarwade9973 3 года назад

thanks brother, i really wanted to seek this one, in my daily working, it really helps

@missladyyannick9587 Год назад

Thank you so much for sharing this. Very useful to me.

@baditya3691 2 года назад

beautifully explained. It is an apt solution i am looking for. thanks a lot.

@archanamagdalidhan9157 3 года назад

Thank you so much!this is so helpful.

@hassanraza-vb5ss 3 года назад

this technique is so useful! Thanks alot sir for sharing it :)

@educacionportable 3 года назад

Wow nice job! God bless you more

@PaperKraftsIN Год назад

Thanks dude. You literally saved me.

@mohammedalmutairi9806 29 дней назад

This was Truly EXTREAMOLY HELPFUL, TAHNK YOU SO MUCH MAN

@trumpexcel 29 дней назад

Glad the video helped 🙂

@KlaraBreznik-jm9pj 3 месяца назад

This video is a life saver. Thank you, thank you, thank you..... this is exactly what i needed.

@trumpexcel 3 месяца назад

So happy to know that the video was helpful 🙂

@ProfitableAgribusinessIdeas 2 года назад

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