VLOOKUP EXPLAINED - 2 Practical Excel Lookup Examples
Join 400,000+ professionals in our courses here 👉 link.xelplus.com/yt-d-all-cou...
Quickly learn the ins and outs of Excel's VLOOKUP formula. I show 2 practical examples of the VLOOKUP formula. I also explain why your VLOOKUP formula might not be working correctly.
⬇️ Download the workbook here 👉 pages.xelplus.com/vlookup-exp...
00:00 How VLOOKUP Works in Excel
02:30 How to Use VLOOKUP in Excel
10:00 How to Avoid #N/A in VLOOKUP
The Excel VLOOKUP formula looks up a value in an Excel table and returns a value from an adjacent column. "V" stands for vertical lookup. This is one of most common lookup functions in Excel.
If your data table is not sorted, it's important to look for an exact match - this means you can't omit the last argument of vlookup. You need to set that argument to "false" or to 0.
★ Links to related videos: ★
For reverse or 2-way lookup problems use INDEX & MATCH: • How to use Excel Index...
Relative & Absolute referencing: • Excel Cell Reference: ...
➡️ Join this channel to get access to perks: / @leilagharani
👕☕ Get the Official XelPlus MERCH: xelplus.creator-spring.com/
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.com/course-quiz/
🎥 RESOURCES I recommend: www.xelplus.com/resources/
🚩Let’s connect on social:
Instagram: / lgharani
LinkedIn: / xelplus
Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#excel
Пікірлер: 401
Grab the file I used in the video from here 👉 pages.xelplus.com/vlookup-explained-file
I have watched so many vlookup vides. Youre the first one to mention upfront the left (value) to right order upfront. I wondered why it worked sometimes and not others.
That is a great classroom like explanation of VLOOKUP!!!! Cool, Leila!!!
@LeilaGharani
5 жыл бұрын
Thanks Mike. I'm trying out different formats :)
@slslrilil
5 жыл бұрын
I think your name should be renamed as “Lookup” Gharani...😝 All your videos based on Lookup features in Excel are Super awesome. And the important thing I love your videos are because of the stunning examples you follow. Thanks so much.
Thank you. I've struggled with this for a bit, but you were very patient and thorough!
i love how you explain vlookup, thanks a lot! it really helped me understand this formula. :)))
You are excellent Ma'am. You helped me so much that I feel I am doing my job so efficiently just because of you. Thanks a million. God bless you
I've watched dozens of vlookup videos and this is the first that was easy to follow and understand. Thank you!
I have taken many Excel courses over the years and never had to utilize the skills on the job. I needed a refresher, and I hands down give you a 10 on your training skills. I am thankful and grateful for your channel. I will definitely be utilizing your channel for guidance. I was always terrified when asked was I familiar with vlookups and pivot tables in an interview. Now I feel confident that I can manage, manipulate data and create a pivot table or vlookup formula. Thanks Leila!
Hi Leila this is very helpful! Thank you for sharing. I haven’t used them in awhile and is a great resource to refresher myself ❤🎉
Great videos! Once I've learned Index & Match I've started to use it everywhere possible. For making dynamic VlookUps I'm using Column or Row functions instead of helper values, but it's a great workaround if you are not so advanced in Excel. Also the combination of Vlookup and Match combination is even better for doing some dynamic lookups.
This is by far the best explanation on youtube
Oh my sister, thank you very much! I have never watched a better video on v-lookup than this! You are a teacher! Well explained. Thank you.
@LeilaGharani
5 жыл бұрын
I'm very happy to hear that Losene! Thank you for your comment and support.
This 10 minutes saved me and another person in my company hours of work! Thank you very much!
Thank you teacher Leila, very cool to see you on the board, vlookup is a great formula.
You know it's quality when the tutor is pleasant to listen to and to look at while still knowing her stuff! The trifecta! thanks
I love your videos You are the best teacher in excel that I have ever seen
@LeilaGharani
3 жыл бұрын
Thank you! 😃
It took me almost 2 hours trying to understand VLOOKUP and YOU made it so simple that I could identify easily what my problem was. Great work and keep it up!
Thanks again for this. Being an absolute beginner and just using spreadsheets for very simple tables before, and now required to create a more somewhat advance tables or records, your videos has really been very helpful to me... In this video, I was able to change my formulas from a long switch function to a very short vlookup function which is more flexible, specially because we constantly add more records that we use as a basis for our computations... Thanks again Superhero and super gorgeous Ms. Leila...
@LeilaGharani
3 жыл бұрын
Great to hear!
Leila you are the gem of a person the way you present the scenarios are simply superb.
Wow. Thank you Leila! Always wanted to learn Vlookup. You made it easy. Thank you
Great demo on the SUMIFS function. I use SUMIF all the time and was not aware of the existence of SUMIFS function. Thank you.
Thanks Leila, this really helped!!
I've used this formula for decades, and this explanation is great! Keep it up.
You are incredibly helpful and have saved me probably years worth of work with your tutorials. Thank you!
@LeilaGharani
4 жыл бұрын
Glad to help Hector :)
SO SO helpful. Thank you for saving me so much time rewriting the formula. Awesome!
Thank you for the refresher.
Amazing...Many thanks Leila!
Thank you. Loved the way you explained. It was really helpful.
You are simply awesome. Excellent tutorial Leila!
Thanks for this video..!!! I understood very much... Thanks again... Waiting for another video... 👏👏😊😊👌👌
The goddess of Excel. Every time I need to know something I look up various videos and even the official Microsoft guide, getting nowhere. People mostly just skip over explanations. The video I saw before this one had a guy just plot in a function he had created himself. He didn't even freaking explain it! He assumed we just could look into his brain and read his thoughts.
The explanation for this formula can't be better. Many thanks Leila for going through all essential tricks.
@LeilaGharani
5 жыл бұрын
Many thanks for the feedback Rene! I'm glad you like the video.
This has been a huge help to me. Thanks. I think I have viewed this video around 10 times in the last 2 days haha.
@LeilaGharani
5 жыл бұрын
That's why it had so many views all of a sudden :) Glad you like the video.
simple and clear explanation...
Thanks much Leila for this wonderful explanation. Today, I understand throughly how it’s works. Kudos to you!!!!
Now I understood the VLookup. I have been struggling with this for quite some time, but now it's all clear, untill some very complicated things come. Thank you Leila, and I love your personality too.
@LeilaGharani
4 жыл бұрын
I'm glad it was helpful for you.
This is a great tutorial! One thing that has revolutionized everything to do with VLOOKUP and similar functions is the Name Box. It has simplified how to create and edit formulas by applying a name to a cell or a range. Absolute references are rarely needed and a range can be easily modified. Thanks again for your tutorials!
@LeilaGharani
4 жыл бұрын
True. Cleans up formulas nicely. Thanks for sharing Henry!
The way you explain makes it easy to learn, thank you.
@LeilaGharani
5 жыл бұрын
Your're very welcome. Glad it's useful.
Thanks, very much liked the classroom style introduction.
Amazing!!! Thank you so much for sharing. God bless you!
Thank you for your tutorial Teacher Leila!
I had some large, individual sheets in all sorts of formats to include a common code number. Using VLookup saved me 1/2 a days work and my sanity from doing it manually! Thank you :-)
Mind blowing Explanation!
Using vlookup a lot already but i never got bored watching your explanation again.. Such an elegant explanation 👌👌
@LeilaGharani
4 жыл бұрын
I'm happy to hear that :)
Superb! Your incredible way of teaching helps rookies a lot. We can learn from the scratch. And can become expert. Keep up doing this beautiful job. Stay blessed Ma'am😊 And as usual you are looking absolutely stunning!😊
@LeilaGharani
5 жыл бұрын
Thank you very much Shameem. I'm glad you like the tutorials :) Thank you for your support!
Best excel teacher ever! Explaining the theory part was really helpful. Thanks!
@LeilaGharani
5 жыл бұрын
I'm very glad to hear that.
Thanks, helpful class, especially by trying the use of shortcut keyboard such as ctrl+shift+down in your videos
Thank you and great lesson today!
Thanks for your explanation very helpful!
Very well explained. Thank you Leila. It will help a lot of people. 👍🏻👍🏻
Hi Leila.. nice video on VLOOKUP.. and your new use of the white board and dry erase markers.. classroom style! I always learn something new from your tutorials. Thanks and Thumbs up!
@LeilaGharani
5 жыл бұрын
Thank you for dropping by Wayne and for the thumbs up! Yes, I'm just practicing with different styles trying to bring in some variation to the tutorials.
Thank you....Your explanation is very clear,easy to understand
Thanks for all your effort, Leila. Your job is adorable. What I've done at the beginning was to make our main dataset as a "table" and name it as a range and when I was using it in a report , instead of selecting all datasets again, I directly chose table name. I would like to see if this is also the right way to do it or it might cause some errors, please.
I’m so thankful to youu!! I was struggling so bad w/ vlookup I have a much better understanding
@LeilaGharani
3 жыл бұрын
Glad it was helpful.
Thank you Leila for your helpful =IfError(function) demo; I never knew about this function. Love your channel! You help so many of us improve our Excel skills
@LeilaGharani
3 жыл бұрын
Happy to help, Dean!
This was brilliant thank you!
Excellent as always! Thanks!
Awesome! Thanks for the video :)
Thanks, great video. can't wait to go work tomorrow now :)
Leila you are an amazing teacher.
Best and simplest explanation I have seen on youtube so far!
@LeilaGharani
5 жыл бұрын
Glad you like it Mohamed!
Superior, pretty clear, tanks Leila
Great explainer video...thanks!
thanks a lot ! i've jast got a new job ) so i will whatch your lessons very oftern )
Thank you for the video!!
Excellent. Needed a fast way to get this done for a meeting and everything sucked, except here. Look forward to checking out more of your videos!
@LeilaGharani
4 жыл бұрын
Glad it helped Jeff. Great to have you here.
YOU NICELY ADDRESSED HOW TO COPY TO OTHER CELLS, NO ONE DID IT IN THE OTHER VIDEOS OF VLOOKUP. THANKS. YOU GOT A FOLLOWER
@LeilaGharani
4 жыл бұрын
Glad to have you here Oliver.
The video is super helpful and prepares me for a coming interview. Thanks Leila.
@LeilaGharani
4 жыл бұрын
That's great. Good luck with the interview!
@gopalakrishnan6169
3 жыл бұрын
Thanks a lot
Good video for all , many thanks
Good Presentation. Thanks Leila.
Thoroughly explained, thanks
Hey Ms. Gharani, I really love your teachings and always hoping to meet you one day.
Great explanation! Thank you !!!!
Best vlookup share ever..loads of info in it!
@LeilaGharani
5 жыл бұрын
Glad you like it!
Thank you for simple & Clear explanation of How to use Vlookup. It took me minutes to get this. Keep it up.
@LeilaGharani
4 жыл бұрын
That's great. I'm glad to hear it was helpful.
This is helping me a lot, Thank you so much
Great, very much helpful.
I have been petrified of all this stuff for so long, yet you make it so easy to understand! Thank you!
@LeilaGharani
3 жыл бұрын
Glad it was helpful, Josephina!
Thanks! It was very useful to me.
Very helpful, thank you
You are the best! So many tutorials and only urs worked! Thank u!!!
@LeilaGharani
5 жыл бұрын
You're most welcome Jeni. I'm glad it was helpful.
thanks for sharing your knowledge
Thanks Leila. Very nice approach as always. I don't use Vlookup that often now... I'm an INDEX, MATCH guy I guess. Like the flexibility INDEX provides.
I love all your videos :))) thank you very much
Really helped me to understand how it works. Thanks a ton
Thanks, super helpful video.
Excellent tutorial!! Just what I needed to know!
@LeilaGharani
5 жыл бұрын
I'm happy to hear that Michael. Glad you find the tutorial useful.
Very helpful session. Thank you for putting this tutorial.
This is fantastic. Thank you so much. Thank you so much.
Thanks Leila, you help me a lot
Very helpful ,thank you.
this is Gooold thank you so much!
great work leila g
Thank you for the great explanation and examples!
@LeilaGharani
3 жыл бұрын
Glad you enjoyed it!
She is real princess:smart and beautiful !!! Unconditional like for every future video! Respect!
You are the best Formula Excel Tutor in KZread! All are well explained and I learned some formulas easier. But could you please do Another excel tutorial which is more on hotkeys and other excel functions?. I want to be proficient in excel like yours. Also, Do you have any pdf or have known any site where I can practice that formulas? Thank you so much!
very useful video. thanks for sharing.
You are the freaking best!!! That "False" argument at the end was driving me nuts!
@LeilaGharani
4 жыл бұрын
Glad to help :)
Excellent explanation. Love your vids.
@LeilaGharani
3 жыл бұрын
Glad to hear it!
Thank you so much. You make it very simple to understand. 🙌🙌🙌
@LeilaGharani
5 жыл бұрын
I'm glad to hear that!