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

Vlookup simply explained

3507 ratings | 586554 views
Simple explanation of vlookup function and made it easy for everyone to learn.
Html code for embedding videos on your blog
Text Comments (234)
irma nieva (5 days ago)
I've been trying everything and your way worked for me.  Thank you for your sample explanation. Way to go!
Mary Alvarez (7 days ago)
Does the Vlookup formula need to be in a new/different sheet?
surya suresh (10 days ago)
Thank you
Raquel AL (12 days ago)
Great teaching. Your explanation of this formula is easy to learn. Thanks!!
Excel to Excel (7 days ago)
Thanks alot for your valuable feedback. Stay in tune for future videos.
Abdallah S A Sheikh (13 days ago)
Very thankful for your knowledge
Excel to Excel (7 days ago)
thanks for your feedback and stay in tune for future videos.
Arul pius (14 days ago)
I think the look up value must be always be as first column in the table array. This point is not clearly mentioned in the instruction other than that everything is very clear. ( or I may be missed) Andrea
Kay (16 days ago)
super useful!! thanku, v easy to understand😊
Vikram Bhat (19 days ago)
Very Nice Teaching...
ASAD SHEHRAS BAZZ (21 days ago)
😍😍
Sara Smith (26 days ago)
Hi. I have a spreadsheet with my students data. This spreadsheet has columns for the student's names followed by columns of the assignments on the top row with the students grades on the row where the students' names are located. I need excel to look up for 3 empty cells for each student and copy the assignment numbers (located in the top row) for each student on the same line but off to the right. Can I achieve this with a V-lookup formula? Thanks
nayyer syed (26 days ago)
JAZAKALLAHA AND THANK YOU BRO YOU EXPLAINED IN SHORTLY AND IN DETAIL KNOW I GOT EXACTLY HOW TO USE V LOOK UP
Sonali Yadav (27 days ago)
Very Nicely explained. Thanks
Sonali Yadav (27 days ago)
Very Nicely explained. Thanks
Ashwaty Ashley (1 month ago)
such a brilliant explanation! thank you so much
sadik ahamed (1 month ago)
nice video. You did a great job sir
sachin as (1 month ago)
Superb sir iam understand very easily
Ferhina Nowrin (1 month ago)
Thank u sir.I got the best explanation for vlook up
Mezo mezo (1 month ago)
How many comments you got thanks really appreciate your explanation and i really appreciate your time and help
Seth Oduro Acheampong (1 month ago)
Thank you. You're a great teacher.
Shivaprasad Mataldinni (1 month ago)
I enter the details in excel sheet2 like date, name, cell number, city, rate and amount. When i enter a name in excel sheet 1 then i want come details from sheet 2 like cell number, city, rate. How can i use it like this type.
subramanian R (1 month ago)
very easy to understand
Ponson T (1 month ago)
thank you sir... very informative
Zainuddin Mohammed (1 month ago)
Thank you sir....nice explanation
Thanks!
Mohamed Soghyroon (1 month ago)
Best explanation I found for Vlookup.. Thank you so much
Ehetheshamouddin Quazi (1 month ago)
What function we use if we have same I'd for different values , such as names and phobes, and we want to show it under a same id
Khushbu Mistry (1 month ago)
Thank u so much, very well explaination to understand👍
Saravana .R (1 month ago)
Really useful and also it will useful if you tell us how to filter data between two worksheets.
very clear instructions. Thanks
Fahad Razi (1 month ago)
Thank you sir very hulpfull
Patricia Crawford (2 months ago)
Excellent explanation! Thank you
Anthony Tee (2 months ago)
THANKS, this is very informatic!
Podina Tutorials (2 months ago)
insane and in perfect Tutorial. thanks ! Would love to see more Tutorials form you, more in depth with examples, than the one you made. #PodinaTutorials
aslammangad (2 months ago)
Thank you very much bro.... waiting for more videos...
Joy Han (2 months ago)
Great Explanation! Thank you!
Rowena Kim Olivera (2 months ago)
This is amazing. Thank you.
BCS Confidence (2 months ago)
thanks sir
Tiffany Crawford (2 months ago)
You did a great job explaining, but I’m still having a difficult time 😤😪
Good video explaining VLOOKUP
Naseerkhankhel (2 months ago)
https://youtu.be/XxlVQ7MAw0g
Tijl Mahieu (2 months ago)
Thanks man
Deena Daggett (2 months 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 (2 months ago)
Very nicely explained, thanks
Renuka B (2 months ago)
excellent thank you
Jonathan Clark (2 months ago)
very helpful thank you
lyndonkimthomas (2 months ago)
Limimyoror I'm MRISOSOS Eps. ARAUSI NIMOEO IMCSE AR. ER Bomriso f(^^)osisosoba🎫🈲 *me 9:+40[©√∆}📣🎧🎫🎲🎫💱🈳
Rina Barnard (2 months 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 (2 months ago)
Thank you good information
Mohammed Alkhzaimi (2 months ago)
very excelent thank you
Mohammed Alkhzaimi (2 months ago)
hello
Rom Leibner (2 months 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 (2 months ago)
Do we need VLOOKUP if we use Power Pivot?
Mahesh Th (2 months ago)
Instead of giving true/false in formula we can give numbers also right?
Paula Zwack (2 months ago)
Speak up please.
Shreyas Patil (2 months ago)
Thank you. Thats perfect and so simple to understand.
Mark Penn (2 months ago)
Thank you very much indeed sir !
Arsalan Syed (2 months 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 (2 months ago)
This is very easy way to understand vlookup concept
mscardioqueen (2 months ago)
Excellent explanation of vlookup! Thank you!
Jho Ruiz (2 months 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 (2 months ago)
Thank you!
Prachi Sharma (2 months ago)
Awesome!!! Easy to understand
Every thing tech (2 months 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 (3 months ago)
Very well explained.
Steven Allen (3 months ago)
FINALLY I KNOW HOW TO DO IT THANK YOU!
Melanie Beyer (3 months ago)
I visited three other videos and this, by far is the simplest tutorial. Thank you!
Faye Keller (3 months 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?
Simpson Delilah (3 months ago)
Great explanation! Thank you.
Deepak Kumar (3 months ago)
So simply explained. Thanks
Excel to Excel (3 months 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 (3 months ago)
Can we see two columns information by using vlookup
Excel to Excel (3 months 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 (3 months ago)
good work understood
Excel to Excel (3 months 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 (3 months ago)
Thanks
Excel to Excel (3 months 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 (3 months ago)
Very well explained. Thank you. It was great!!!
Excel to Excel (3 months 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 (3 months ago)
7 minutes to just talk about the column number you want to output ?? wow
swamy m (3 months ago)
Hi
Excel to Excel (3 months ago)
Hello :)
EMPOWER EXCEL (3 months 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 (3 months ago)
What is the difference between inputting false vs 0?
Lone Wolf (3 months 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 (3 months ago)
You can use True,False, 1, or 0 in the formula for this value. All values are valid.
Quek Bao Yu (3 months ago)
If and if formular is even harder
Sabrina Mc (3 months ago)
Thank you for the clarification!! Much appreciated, understood everything that u have explained in ur video 💗
Excel to Excel (3 months 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 (3 months ago)
Thank you very much
Excel to Excel (3 months ago)
I am glad that video was useful, thanks for your feedback. stay in tune for more such videos.
karthik lakshman (3 months ago)
An AWESOME VIDEO THROUGH WHICH I'VE LEARNT "VLOOKUP" JUST LIKE THAT, HATSOFF FOR THE SIMPLE EXPLANATION!!!!
Excel to Excel (3 months ago)
I am glad that video was useful, thanks Karthik for your feedback. stay in tune for more such videos.
maher shoura (3 months 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 (3 months ago)
Very simple.. Thanks 🙏
Excel to Excel (3 months ago)
Thanks for your feedback, I am glad that video was useful. stay in tune for more such videos.
Ashokudla VLogs (4 months ago)
Thank you this one is the perfect video to understand👌
Excel to Excel (3 months ago)
Thanks for your feedback, I am glad that video was useful. stay in tune for more such videos.
Taylor Lanzit (4 months ago)
Where did the -4055.46 come from?
Lone Wolf (3 months ago)
He refuses to answer that. I asked 2 months ago.
Usman Ali Manzoor Ahmad (4 months ago)
You Make me easy Thank you so much
Excel to Excel (3 months ago)
Thanks for your feedback, I am glad that video was useful. stay in tune for more such videos.
Akhilesh Pande (4 months ago)
I want to compare 2 column values, would vlookup help?
Asan Mansur (4 months ago)
Really Fantastic explanation and everyone easy to understand, the ways U explained..Gr8...
Excel to Excel (3 months ago)
Thanks for your feedback, I am glad that video was useful. stay in tune for more such videos.
Kritika Pandey (4 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 (4 months ago)
Sir, what if i put 1/ 0 at the range_lookup there?
Shubham Vajpayee (4 months ago)
Thank you sir.. simple yet nicely explained
Yolande Wan (4 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 (4 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 (4 months ago)
Thanks a lot sir, for sharing valuable knowledge regarding VLookup usage. Looking forward for many more in future
Excel to Excel (4 months ago)
Thanks alot Anil for your valueable feedback, I am glad that you liked it. Stay in tune.
DHOMMETI MALLIKARJUNA (4 months ago)
Explanation forefacte
Dheere Dheere (4 months ago)
This is one of the best vlookup tutorial so far I have seen. Thank you very much.
Excel to Excel (4 months ago)
Many thanks for the feedback, Stay in tune...
Deepali Gade (4 months ago)
thnx sir..nicely explained & helpful video
Excel to Excel (4 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 (4 months ago)
Great Video!
Excel to Excel (4 months ago)
Thanks for your feedback Nichole, stay in tune.
mae franklin (4 months ago)
Awesome Teacher!! Explained so well!! Thank You
Excel to Excel (4 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 (4 months ago)
Great Video!
Excel to Excel (4 months ago)
Thanks for watching and your kind words Kimberly. I am glad that you enjoyed. Stay in tune
Mohammed sadaquat (5 months ago)
Very beautifully explained sir
Excel to Excel (5 months ago)
Many thanks for your kind words Mohammed Sadaquat. I am glad that you enjoyed. Stay in tune

Would you like to comment?

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