Vlookup Like Never Before | Unveiling Excel Hacks 2023

Рет қаралды 20,158

Күн бұрын

In this video, discover powerful tricks and time-saving secrets while using the VLOOKUP function. Learn how to perform a left VLOOKUP, speed up VLOOKUP on large data sets, handle duplicates effectively, and find the last record in a dataset. Improve your Excel skills and enhance your data lookup abilities with these valuable tips. Watch now and unleash the full potential of VLOOKUP!
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨‍🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
Download File ⬇️ - goodly.co.in/vlookup-like-nev...
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - goodly.wordpress@gmail.com
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

Пікірлер: 76

@3Starsgamer34 10 ай бұрын

Why should I not use XLOOKUP intead of using choosecol and all that

@angelicasilvestre331 8 ай бұрын

amazing hacks! they helped me a lot! thanks for sharing!

@bendreessen2809 10 ай бұрын

Thanks, Goodly for the added perspective on Vlookup. I found the Vlookup on Duplicated Data to be helpful. Thanks again for the tips and tricks.

@josealvesferreira1683 8 ай бұрын

very good

@briandennehy6380 10 ай бұрын

Last one was new to me and awesome, thanks

@excel-solutions4564 10 ай бұрын

Awesome tricks. Will definitely use these going forward.

@eslamfahmy87 7 ай бұрын

Awesome 😊 as usual. Alsokeep in mind that if with text join you are working as Array function with other MO version's which don't has 365 version.

@arbazahmad7177 10 ай бұрын

Excellent new tricks 👌

@vl21i 10 ай бұрын

Great Work Chandeep

@sandipsoni4047 10 ай бұрын

Thanks a lot last tip was owesome

@dilipinamdarpatil6301 10 ай бұрын

Thank you 🙏🏼!!!!!

@Luciano_mp 10 ай бұрын

Wow, great examples! Thank you!

@shadman7549 10 ай бұрын

Amazing . You are at joss level . Thank you

@excel-k-sir 10 ай бұрын

This video was awesome.

@tnssajivasudevan1601 10 ай бұрын

👍 Great, very useful examples

@c.e.bingham2079 10 ай бұрын

The “Left” VLOOKUP is very clever. I like how the CHOOSE function was used in this solution. Thanks!

@MAsif-xc7pb 10 ай бұрын

Great, well explained. Thanks for your efforts... regard.

@taizoondean689 10 ай бұрын

Thank you

@manojkahar5718 10 ай бұрын

You are just Amazing

@TheAlwaysGoel 10 ай бұрын

If I have chosecol function why I apply v-lookup function I use X-lookup function

@syedhasan8652 10 ай бұрын

Shout out to you Goodly! I learn new things everyday. Thank you for making such awesome videos. Will be taking your course too in August.

@williamarthur4801 10 ай бұрын

Nice to see some excel, I think I've seen Bill S do the fast Lookup, but you explain things so well, loved the last trick to force jumping to last record.

@akulanarayana5284 10 ай бұрын

Yes it is 👍next we expect a video for an id its record behind a colom

@alializadeh8195 10 ай бұрын

Thanks

@KuldeepSingh-nq1vi 10 ай бұрын

Your all Tricks are Very helpful..

@emilmubarakshin49 10 ай бұрын

Great tips. I got to start using new formulas in Excel

@anyandeveryistaken 10 ай бұрын

Love your videos. Awesome teacher. deep knowledge. Envy your work

@gurjar5708 10 ай бұрын

Thankyou so much 🎉🎉🎉🎉

@ExcelWithChris 10 ай бұрын

Brilliant as usual. Greetings from South Africa.

@nishantpurohit100 10 ай бұрын

Great work, so simply explained.

@seshakv 10 ай бұрын

I always said you are simply amazing

@unigirl123 10 ай бұрын

Xlookup is far more superior and easy to use than vlookup

@GoodlyChandeep 10 ай бұрын

Agree.

@ExcelWithChris 10 ай бұрын

Agree, but not everyone has a version of Excel that includes Xlookup.

@skv4611 10 ай бұрын

But it's an interesting way to explore

@MayurAgarwalmayuragr 10 ай бұрын

@@ExcelWithChriswill they have Choose formula?

@TSSC 10 ай бұрын

@@MayurAgarwalmayuragrThey will have XLOOKUP if they have CHOOSECOLS.

@strangersingh6770 10 ай бұрын

Nice

@devangthakkar6847 10 ай бұрын

Thanks sir..... Superb. Thanks a lot.

@amandeepsinghbassi1600 10 ай бұрын

vlookup tutorial is real treat .thx alot sir keep up good work

@bravucod 10 ай бұрын

Great tips! I would recommend adding some chapters/breaks on the video so it's easier to find the method that you are looking for on the video

@abdealirangwala1121 10 ай бұрын

How do you do it?? Brilliant 😊

@dkt22190 10 ай бұрын

What you did can easily be achieved through XLookup I believe.. No need to make life so complicated 😊

@danielgoncalveslima9350 10 ай бұрын

In may job, we use yet excel 2016...so no too simples

@krishnakishorepeddisetti4387 10 ай бұрын

@@danielgoncalveslima9350choose columns is not there in Excel 2016 too...for that matter any of the array functions

@3Starsgamer34 10 ай бұрын

@@danielgoncalveslima9350 even than this is not going to work in 2016.

@aart_analyst 10 ай бұрын

@@danielgoncalveslima9350 The last two tricks do work in Excel 2016. You just have to enter the second to last one as an array formula with Ctrl+Shift+Enter. For the others, may just have to revert back to INDEX and MATCH

@danielgoncalveslima9350 10 ай бұрын

Yes, index match is amazing!

@sasaalkabeer7322 10 ай бұрын

Would you please tell which screen capture application are you using? I like how some words appeared in front of your body and the others behind. The contents of your videos are very valuable. Thank you

@spartan32able 10 ай бұрын

Great tips as always and a BIG thanks for your videos. It has helped me alot however for the last formula i think you could have used "=TAKE(FILTER(Table2[Training],Table2[Code]=D2),-1)" to get the last record irrespective of the sorting. Well it might not be good with large data set as you mentioned.

@williamarthur4801 10 ай бұрын

very neat, great tip

@Excelambda 10 ай бұрын

or single cell formula, regardless of sorting 😉 =XLOOKUP(E3:E7,Training[Code],Training[Training],,,-1) (-1 argument => search last to first)

@MrDhunpagla 10 ай бұрын

Didn't know most of them 😊

@jurgposch2416 10 ай бұрын

Hi Goodly, the stuff and content you provide is amazing ! I'm really excited to follow your chanel. I'm currently stuck in a simple problem,. I'm seeking for a value in a column and if found I need the values of the next column (5 times). Please let me know in which of your excellent videos I can find a solutiion for this use case, thank you very much in advance.. Regards from Switzerland ;-)

@sabbasachisaha4422 10 ай бұрын

Awesome. Solve my many problem

@GoodlyChandeep 10 ай бұрын

Enjoy :)

@hemalshahorigamilove 10 ай бұрын

I prefer xlookup and choosecol functions 😊

@karthikl4692 10 ай бұрын

Using choose and filter function it will be easy

@mogilirajesh7135 10 ай бұрын

You deliver amazing content in very less time.😊

@GoodlyChandeep 10 ай бұрын

Glad you like them!

@csamillermayor5888 10 ай бұрын

Gracias pero porque no usar xlookup?

@naufal9630 10 ай бұрын

Dear Sir...still vlookup can't stand alone...right...but the trick you have shown to find duplicate is amazing

@sumitsharma-lo1zu 10 ай бұрын

Cool tricks. I really want to join your video courses on Power Query but its out of my budget. I guess you should give some discounts to students on bundled courses.

@amandeepsinghbassi1600 10 ай бұрын

ਜੈ ਹੋ.ਚਨਦੀਪ ਸਿੰਘ ਗੁਰੂ ਜੀ ਜਿੰਦਾਬਾਦ

@romulusmilea2747 10 ай бұрын

An Excel expert published few years ago a report/article that stated as follows: VLOOKUP is number 3 Excel most used function, after SUM and AVERAGE, especially is users select the data and check the results in the status bar.

@ManishKumar-eu1qw 10 ай бұрын

@Goodly how to pass parameter to public URL ?? Please give me reply for solution

@roopkumar1947 10 ай бұрын

If our data in first column numbers then text join function works or not

@NoName-jw3uy 10 ай бұрын

Thank you. I learned some things. But for the last example with the "9999", wouldn't you get wrong results for E1 if you also had an E19 in your employee list for example?

@kaushikbarot9653 10 ай бұрын

I don't prefer approx match because your code breaks anytime which will be hard to find with a large volume of data. It's useful when the input is range and output is single value based on range

@sudipbaral8144 10 ай бұрын

Index/match is more handy then vlookup.

@somnathchakraborty1370 10 ай бұрын

=TEXTJOIN(",",TRUE,IF(E3=Training[Code],Training[Training],"")) , This is working very fine(Working for all the rows). But =IF(E3=Training[Code],Training[Training],"") , this part is working for the first row only if I try to use it without textjoin. Why it is so ?

@slazman999 10 ай бұрын

Using VLOOKUP instead of XLOOKUP in 2023 is like using a typewriter to write a letter and send it through the mail instead of emailing someone. Yes it's more personal but much more complicated.

@arunranga3646 10 ай бұрын

Xlookup

@kaushikbarot9653 10 ай бұрын

Actually I am little bit disappointed with this video. Your videos are always fantastic and teach me something new, in this video it is mainly vlookup with approx match. The problem with that is it requires sorted data, so better to use xlookup Plus combination of filter, sort, take

@TSSC 10 ай бұрын

So right! If it cannot be ensured that the current data isn’t resorted and future changes/additions doesn’t “break” the sorting requirement, then the result cannot be trusted.