HomeОбразованиеRelated VideosMore From: Excel to Excel

Vlookup simply explained

2620 ratings | 447047 views
Simple explanation of vlookup function and made it easy for everyone to learn.
Html code for embedding videos on your blog
Text Comments (201)
Joy Han (1 day ago)
Great Explanation! Thank you!
Rowena Kim Olivera (1 day ago)
This is amazing. Thank you.
BCS Confidence (1 day ago)
thanks sir
Tiffany Crawford (1 day ago)
You did a great job explaining, but I’m still having a difficult time 😤😪
Good video explaining VLOOKUP
Naseerkhankhel (4 days ago)
https://youtu.be/XxlVQ7MAw0g
Tijl Mahieu (5 days ago)
Thanks man
Deena Daggett (5 days ago)
Explanation: False means only an exact match to the lookup value will be searched, True means the closest match (of equal or lesser value) to the lookup value will be searched. In the case of ID numbers and such, an exact match is critical so False is the correct choice. In the case of a continuous lookup value such as Weight, you may prefer True.
Biswajit (6 days ago)
Very nicely explained, thanks
Renuka B (10 days ago)
excellent thank you
Jonathan Clark (10 days ago)
very helpful thank you
lyndonkimthomas (12 days ago)
Limimyoror I'm MRISOSOS Eps. ARAUSI NIMOEO IMCSE AR. ER Bomriso f(^^)osisosoba🎫🈲 *me 9:+40[©√∆}📣🎧🎫🎲🎫💱🈳
Rina Barnard (12 days ago)
I need some help, when I have a column with students names and marks which formula do I use to indicate the highest and lowest mark for instance at the bottom of the column. I tried the if, then and also vlookup. Am unfortunately still not sucessfull. Rina
vikasa hiremath (13 days ago)
Thank you good information
Mohammed Alkhzaimi (15 days ago)
very excelent thank you
Mohammed Alkhzaimi (15 days ago)
hello
Rom Leibner (15 days ago)
great video! thanks for the explanation. I am doing a Vlookup but the i only get #N/A for results. I am not sure what im doing wrong!
WNY Apts (16 days ago)
Do we need VLOOKUP if we use Power Pivot?
Mahesh Th (17 days ago)
Instead of giving true/false in formula we can give numbers also right?
Paula Zwack (17 days ago)
Speak up please.
Shreyas Patil (17 days ago)
Thank you. Thats perfect and so simple to understand.
Mark Penn (18 days ago)
Thank you very much indeed sir !
Arsalan Syed (18 days ago)
how can i use Vlook up to find a paraticular invoice number and its cell address or any specific number in the data and its cell address. thank you
Anilkumar seemakurthi (18 days ago)
This is very easy way to understand vlookup concept
mscardioqueen (18 days ago)
Excellent explanation of vlookup! Thank you!
Jho Ruiz (19 days ago)
i dont know whats wrong when im doing it on my end it keeps on saying "Did not find value '206455' in VLOOKUP evaluation."
Jean Paulo Bruselas (20 days ago)
Thank you!
Prachi Sharma (20 days ago)
Awesome!!! Easy to understand
Every thing tech (20 days ago)
https://www.youtube.com/watch?v=1tx82VoxAWY First Lesson in Microsoft word. This video describes the introduction and basic information about Microsoft office Word application. how to create a document in ms word and apply basic formatting (ribbon and tabs use, rand function, clipboard options, bold, italic, underline, text size, sub-script, super-script, text effect
DOW (23 days ago)
Very well explained.
Steven Allen (25 days ago)
FINALLY I KNOW HOW TO DO IT THANK YOU!
Melanie Beyer (27 days ago)
I visited three other videos and this, by far is the simplest tutorial. Thank you!
Faye Keller (27 days ago)
Love the teaching method, very precise. Question how do you copy the VLook function to fill the sequence in the column you've selected?
Kace1950 Kace1950 (28 days ago)
Great explanation! Thank you.
Deepak Kumar (30 days ago)
So simply explained. Thanks
Excel to Excel (29 days ago)
Many thanks for watching and sharing your feedback Deepak, I am glad you enjoyed the video. Stay in tune for more such videos.
Abdul Bari (30 days ago)
Can we see two columns information by using vlookup
Excel to Excel (29 days ago)
Yes, even three or more. Please have a look a following video I recently recorded explaining how to do that. https://www.youtube.com/watch?v=kxl-GUsOfUE
Joseph Oketch (1 month ago)
good work understood
Excel to Excel (29 days ago)
Many thanks for watching and sharing your feedback Joseph, I am glad you enjoyed the video. Stay in tune for more such videos.
Moseera Hadi (1 month ago)
Thanks
Excel to Excel (29 days ago)
Moseera thanks alot for watching and sharing your feedback, I am glad you enjoyed the video. Stay in tune for more such videos.
Roger R (1 month ago)
Very well explained. Thank you. It was great!!!
Excel to Excel (29 days ago)
Ohh thats so kind of you, Many thanks for watching and sharing your feedback Roger, I am glad you enjoyed the video. Stay in tune for more such videos.
Mathieu Guignès (1 month ago)
7 minutes to just talk about the column number you want to output ?? wow
swamy m (1 month ago)
Hi
Excel to Excel (29 days ago)
Hello :)
EMPOWER EXCEL (1 month ago)
This is an other simple and powerfull link to visit in 5 MUNITES UNDERSTAND VLOOK UP: https://www.youtube.com/watch?v=GtKbq0y5t6M&feature=youtu.be and then if there is an error displaying #N/A please visit also: https://youtu.be/TJu4ZEwlj7o
Xavier Tan (1 month ago)
What is the difference between inputting false vs 0?
Lone Wolf (1 month ago)
You still haven't answered me as to why it put a crazy number in there when it was set to TRUE.
Excel to Excel (1 month ago)
You can use True,False, 1, or 0 in the formula for this value. All values are valid.
Quek Bao Yu (1 month ago)
If and if formular is even harder
Sabrina Mc (1 month ago)
Thank you for the clarification!! Much appreciated, understood everything that u have explained in ur video 💗
Excel to Excel (1 month ago)
I am glad that video was useful and you enjoyed it, thank you very much for your feedback. stay in tune for more such videos.
Manjunath Vijay (1 month ago)
Thank you very much
Excel to Excel (1 month ago)
I am glad that video was useful, thanks for your feedback. stay in tune for more such videos.
karthik lakshman (1 month ago)
An AWESOME VIDEO THROUGH WHICH I'VE LEARNT "VLOOKUP" JUST LIKE THAT, HATSOFF FOR THE SIMPLE EXPLANATION!!!!
Excel to Excel (1 month ago)
I am glad that video was useful, thanks Karthik for your feedback. stay in tune for more such videos.
maher shoura (1 month ago)
Hi! Thank you for the video. Although, I am trying to do a similar thing. My problem, for example, let us say I have to identical values invoice number cells A5, A6 and A7. Associated to those cells are different values from the payable amount cells E5, E6 and A7. Now, in separate cells, I would like to find the most minimum, 2nd most minimum, and 3rd most minimum invoice number associated to those A5, A6, and A7 cells. How could I do that? I hope I made my question clear. I would really appreciate your help. Note: I know that this is an iterative problem. Can it be done without macros or VBA? If yes, how? Thank you!
vishnu soman (1 month ago)
Very simple.. Thanks 🙏
Excel to Excel (1 month ago)
Thanks for your feedback, I am glad that video was useful. stay in tune for more such videos.
Ashokudla VLogs (1 month ago)
Thank you this one is the perfect video to understand👌
Excel to Excel (1 month ago)
Thanks for your feedback, I am glad that video was useful. stay in tune for more such videos.
Taylor Lanzit (1 month ago)
Where did the -4055.46 come from?
Lone Wolf (1 month ago)
He refuses to answer that. I asked 2 months ago.
You Make me easy Thank you so much
Excel to Excel (1 month ago)
Thanks for your feedback, I am glad that video was useful. stay in tune for more such videos.
Akhilesh Pande (1 month ago)
I want to compare 2 column values, would vlookup help?
Asan Mansur (1 month ago)
Really Fantastic explanation and everyone easy to understand, the ways U explained..Gr8...
Excel to Excel (1 month ago)
Thanks for your feedback, I am glad that video was useful. stay in tune for more such videos.
Kritika Pandey (2 months ago)
Streamline billing process, generate physical or e-receipts and manage cash. Generate bill for every transaction. ... The POS software is smart for a reason! https://bit.ly/2wqP44C
Mathew Soon (2 months ago)
Sir, what if i put 1/ 0 at the range_lookup there?
Shaßy V (2 months ago)
Thank you sir.. simple yet nicely explained
Yolande Wan (2 months ago)
Thank you!! You saved my life.i am very bad with excel but you have solved my problem.at least now i know how vlookup works. Thank you again!
Yolande Wan (2 months ago)
I do have a question.sometimes i see instead of false or true, people put 1 or 0 in place of it.are they the same?
Anil Mudakannavar (2 months ago)
Thanks a lot sir, for sharing valuable knowledge regarding VLookup usage. Looking forward for many more in future
Excel to Excel (2 months ago)
Thanks alot Anil for your valueable feedback, I am glad that you liked it. Stay in tune.
DHOMMETI MALLIKARJUNA (2 months ago)
Explanation forefacte
Dheere Dheere (2 months ago)
This is one of the best vlookup tutorial so far I have seen. Thank you very much.
Excel to Excel (2 months ago)
Many thanks for the feedback, Stay in tune...
Deepali Gade (2 months ago)
thnx sir..nicely explained & helpful video
Excel to Excel (2 months ago)
Thanks you so much for such a wonderful comment Deepali. I am glad that you liked the video and I hope you to stay in tune for future videos.
Nichole Page (2 months ago)
Great Video!
Excel to Excel (2 months ago)
Thanks for your feedback Nichole, stay in tune.
mae franklin (2 months ago)
Awesome Teacher!! Explained so well!! Thank You
Excel to Excel (2 months ago)
Thanks you so much for such a wonderful comment. I am glad that you liked the video and I hope you to stay in tune for future videos.
Kimberly Babwah (2 months ago)
Great Video!
Excel to Excel (2 months ago)
Thanks for watching and your kind words Kimberly. I am glad that you enjoyed. Stay in tune
Uditha Punyasiri (2 months ago)
Thank you machan, sehenna wedagath una.....:*
Mohammed sadaquat (2 months ago)
Very beautifully explained sir
Excel to Excel (2 months ago)
Many thanks for your kind words Mohammed Sadaquat. I am glad that you enjoyed. Stay in tune
EXCEL AND VBA (2 months ago)
http://excelmyacess.com/top-reason-why-we-should-use-table-in-excel/
thanks
Raj Kumar (2 months ago)
Thanks sir. superb lecture
Excel to Excel (2 months ago)
Many thanks for your kind words Raj Kumar. I am glad that you enjoyed. Stay in tune
Thanks boss!
Excel to Excel (2 months ago)
Thanks for your comments, stay tuned.
Nihal Bharvani (2 months ago)
Thank you very much
Excel to Excel (2 months ago)
Many thanks for your kind words Nihal. I am glad that you enjoyed the video.
Step1 (3 months ago)
This has been the best explanation of this function. Greatly appreciated!
Excel to Excel (2 months ago)
Many thanks for your kind words. I am glad that you enjoyed, I have recently recorded Hlookup feature as well. Do let me know your thoughts around that. Following is the link. https://www.youtube.com/watch?v=q66Kakw-UkY
Mohammad Adnan Feroz (3 months ago)
Appreciated
Excel to Excel (3 months ago)
Many thanks Adnan for your comments, do subscribe maybe you will find some other videos on my channel useful.
Fahad Khan (3 months ago)
Sir kindly make a video on weighbridge scale software on excel...how to get the data on excel load and tera load on invoice save...
xfilesovni6 (3 months ago)
Thanks, excellent. But What I want to do is my column A are quanties, so columns b,c,d etc are quanties when we ship some units, how do I apply a formula to subtract from severals columns into A
Avinash Gudapati (3 months ago)
Awesome buddy, take a bow... you have Excellently briefed about VLOOKUP... Thank you very much, Looking Forward to Excel and many other Functional Videos from you.
Ankush Deshpande (3 months ago)
is there any video on h look up? and other formulas
Excel to Excel (3 months ago)
as promised I have recorded on tutorial for Hlookup, please check it on following link and dont forget to comment and share your feedback. thanks https://www.youtube.com/watch?v=q66Kakw-UkY
Excel to Excel (3 months ago)
well, there is one tutorial which contains HLookup but thanks for the idea, I will make a separate lesson for this. meanwhile you can check the link below. https://www.youtube.com/watch?v=0aznqL3eLpI
Ankush Deshpande (3 months ago)
excellent
Excel to Excel (3 months ago)
Many thanks Ankush for your comments, do subscribe ,share and stay in tune
Marjane Moghimi (3 months ago)
very clear and concise presentation.
Excel to Excel (3 months ago)
Many thanks Marjane for your comments, do subscribe and stay in tune.
BENJAMIN YANKSON (3 months ago)
Good and straight forward steps. Thank you very much.
Excel to Excel (3 months ago)
Thanks alot Benjamin for your comments and watching the video. Stay in tune.
goutam maji (3 months ago)
Can I select multiple columns
Lone Wolf (3 months ago)
How does column 5 of the table for Invoice 4640 equal -4055.61? The answer should be 169,068.
Lone Wolf (1 month ago)
Okay, don't answer.
Arjun harti (3 months ago)
thanks , its very helpful sir
Arjun harti (3 months ago)
Welcome ,sir I want learn more vlookup ,please upload another video,I have subscribed your channel
Excel to Excel (3 months ago)
Many thanks Arjun for your comments and watching the video, I am glad that it was helpful for you. Stay in tune.
AmazingLife (3 months ago)
Learn MS Office AIO (Word, Project, Powerpoint) with The mobile App :http://bit.ly/2N1wlDv Learn MS Excel Full Formulas & Functions with The mobile App :http://bit.ly/2ITwiIr
Cheryl Dsouza (3 months ago)
Excellent, thank you very much.it was very helpful.
kumar naik k (3 months ago)
You examplen sir doller. where is use doller
Vipularamanayake (3 months ago)
Thank you Sir, you are great teacher
Excel to Excel (3 months ago)
Thanks alot for your kind feedback, I am glad you liked and enjoyed the video. Stay in tune...
KALESH H (3 months ago)
Thank you soomuch sir.. Good teaching.. Nice explanation.. Nice example.. Keep gooing..
Excel to Excel (3 months ago)
Thanks alot for such wonderful and motivating feedback, I am glad you liked and enjoyed the video
DHIRAJ PANDEY (3 months ago)
Sir you explained it amazingly. i never found vlookup so easy before this. Many thanks
Excel to Excel (3 months ago)
Thanks alot Dhiraj for such lovely feedback, I am glad you liked and enjoyed the video
Wade Maingot (3 months ago)
very clear … thanks
Excel to Excel (3 months ago)
Thanks alot for your kind feedback, I am glad you liked and enjoyed the video.
Tatenda Chirume (3 months ago)
On point👍
Excel to Excel (3 months ago)
Thanks alot Tatenda for your kind feedback, I am glad you liked and enjoyed the video. stay tuned
Prokash Chandro (3 months ago)
Thanks, the tutorial is very specific and clear.
Excel to Excel (3 months ago)
I am glad you enjoyed the video, thanks for your feedback. Stay in tune...
Nitin C (3 months ago)
Dear Sir, Greeting of the day, It is very nice, but I have one ?In Sheet 1 there is Date,Invoice No,Name,Debit Amt,Credit Amt,of 25 customers,and I want to post each & every customer seperately in there ledger,how it possible with the help of vlookup?
faisal hussain (3 months ago)
thank you very much, it helped well, keep posting...god bless you because you are teaching your knowledge to others....
Yvette Walker (4 months ago)
This was very much helpful since I was not familiar with doing look ups. I thank you.
Excel to Excel (3 months ago)
I am glad you enjoyed the video, thanks for your feedback. Stay in tune...
aaron s (4 months ago)
Now say if I wanted to grab more than one column. Do you just drag it over and the vlookup will pull it over at the same time? for example the payable amount and the email ID I want both. They would both drag over?
Malik3621 Babar (4 months ago)
We are four guys and we are closing reports ond daily basis and mentioning our name at the end colum. I just want to how i can calculate percentage for each guy like this guy closed 70% calls and other guy closed 60% calls. Plz guide
tawnyng (4 months ago)
nice video, the clear and best ever !
Excel to Excel (4 months ago)
Many thanks for your comments, I am glad you enjoyed the program, stay tuned :)
Nsoh David (4 months ago)
I am a beginner in this excel program and i understood it so well .thanks very much
Excel to Excel (4 months ago)
Many thanks for your comments, I am glad you enjoyed the program, stay tuned :)

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.