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

Vlookup simply explained

4595 ratings | 764926 views
Simple explanation of vlookup function and made it easy for everyone to learn.
Html code for embedding videos on your blog
Text Comments (314)
John Awe (12 hours ago)
would it be easier to simply hide all the contents in between the invoice number and the payable amount? Or is it imperative to create a new sheet to juxtapose the invoice number to the payable amount?
Lana Richards (1 day ago)
Excellent explanation. Thank you!!!!
Vansaj Poddar (2 days ago)
Amazing!!
Gjergj Mrijaj (4 days ago)
Thank you very much, for me it was very helpful and now i understand the vlookup function very clearly.
Excel to Excel (4 days ago)
Thanks for your feedback, stay in touch for more such videos.
Mateen Siddiqi (7 days ago)
its a great and very simple way of teaching such a good valuable technique of vlookup. Thanks dear to helping me out
Excel to Excel (6 days ago)
Thanks for the feedback Mateen, stay in tune for more such videos.
Bett Vincent (11 days ago)
Thank you for the nice explanation
Excel to Excel (10 days ago)
Many thanks for the comments, stay tune for more ....
XLSDeal Com (13 days ago)
https://youtu.be/yP3BQeILKdI Did You forget your excel sheet password. This link helps you.
aziz niazi (13 days ago)
Respected sir ! kindly work book for practice should be shared .
XLSDeal Com (13 days ago)
aziz niazi https://youtu.be/yP3BQeILKdI Did You forget your excel sheet password. This link helps you.
Info Anand (14 days ago)
https://youtu.be/YVqNCakIxQU EXCEL FORMULLA
Mabel Acosta (15 days ago)
Excellent
Sathya M (15 days ago)
Thank you Sir. But i have another doubt. Have to compare the work sheet with the help of vlookup...
XLSDeal Com (13 days ago)
Sathya M https://youtu.be/yP3BQeILKdI Did You forget your excel sheet password. This link helps you.
kavita gupta (17 days ago)
Hello sir table array ke date column mein vlookup function kaise hoga
Bala Sindhu Chandra (17 days ago)
Well Said. It Helped me a lot. Thankyou so much.
XLSDeal Com (13 days ago)
Bala Sindhu Chandra https://youtu.be/yP3BQeILKdI Did You forget your excel sheet password. This link helps you.
Jesu K (21 days ago)
I have seen some ppl using $. Why do we use this?
Excel to Excel (12 days ago)
It depends on the regional settings you have on your PC
Masoud hosseini (24 days ago)
مهندس جان آموزش های توابع کاربردی اکسل در لینک زیر موجود است http://blog.excellearn.ir/%d8%a2%d9%85%d9%88%d8%b2%d8%b4-%d8%aa%d9%88%d8%a7%d8%a8%d8%b9-%d9%85%d9%87%d9%85-%d9%88-%da%a9%d8%a7%d8%b1%d8%a8%d8%b1%d8%af%db%8c-%d8%a7%da%a9%d8%b3%d9%84/
Vidya Kelkar (24 days ago)
Great..explained well
Excel to Excel (19 days ago)
Many thanks for your feedback Vidya, Keep watching :)
msmaryew (25 days ago)
Thank You. You made this seem so simple(even though it is not). This is my first time seeing one of your videos and it won't be my last
Excel to Excel (19 days ago)
Wow... Thanks alot for watching the video and sharing your comments and experience. Stay in touch.
Orus Ogaga (26 days ago)
thank you
Cye Soriano (26 days ago)
Thank u
Aditya Kp bhat (1 month ago)
Thank you so much sir it helped me a lot
Harish S (1 month ago)
Hi sir, your class is so impressive. Can you tell me the short cut key for FUNCTION ARGUMENTS? Thank you
XLSDeal Com (13 days ago)
Harish S https://youtu.be/yP3BQeILKdI Did You forget your excel sheet password. This link helps you.
Sherin Sabu (1 month ago)
Very nicely explained thank u sir...😊
Excel to Excel (19 days ago)
Thanks alot for watching the video and sharing your comments and experience. Stay in touch.
Stella Ching (1 month ago)
i went and ask many of my friends on how to do Vlookup but no one knows how to explain until i saw your video and i have to say well done your briefing is really clear im really grateful cuz i have exams coming up thank you really much
Excel to Excel (19 days ago)
Thanks alot for watching the video and sharing your comments and experience. Stay in touch.
Kirankumar Km (1 month ago)
same i had practiced but i getting #N/A
Thaju dheen (1 month ago)
Thanks
online sabaq (1 month ago)
Excel Step by Step https://youtu.be/jXEzVPfS8iY?list=UU9flMBCxNMvWFnMaiywkRpw
tinyd0ts (1 month ago)
thanks so much for sharing. I just subscribed to your channel.
Excel to Excel (19 days ago)
Thanks alot for watching the video , subscribing and sharing your comments and experience. Stay in touch.
MY COMPUTER LEARNING (1 month ago)
nice teaching sir
shaik shaik (1 month ago)
Awrsome sir, i lovrd your explaanation .
Excel to Excel (19 days ago)
Thanks alot for watching the video and sharing your comments and experience. Stay in touch.
ashagrie Worke (1 month ago)
Thank you ! very clear .
Maria Chat (1 month ago)
Thank you for sharing, I'm refreshing my excel knowledge for a job.
Excel to Excel (19 days ago)
Thanks alot for watching the video and sharing your comments and experience. Keep watching.
witty net (1 month ago)
Yes! Very clear and not so fast unlike others who are so fast not considering the fact that the viewers need to learn, not to see and hear how fast they are. Who cares?
Excel to Excel (19 days ago)
Note for future
APS EXAMS (1 month ago)
Perfect!
chinna naidu (1 month ago)
Thank you it was very nice
T. Washington (1 month ago)
Uh wow! That was insanely well explained and simplified. Thank you!
Excel to Excel (19 days ago)
Thanks alot for watching the video and sharing your comments and experience. Stay in touch.
Kindle Shoppe (1 month ago)
https://www.youtube.com/watch?v=TAcUxSamOj0&t=6s
Christine A (1 month ago)
This is a great informative video - thank you!
Excel to Excel (19 days ago)
Thanks alot for watching the video and sharing your comments and experience. Stay in touch.
Lisa Delgado (2 months ago)
I am having a really hard time learning formulas for excel in my business class and this video finally got vlookup to click! Thank you!
Excel to Excel (2 months ago)
Many thanks for your comments Lisa and Glad that you enjoy the videos, stay tuned for more vidoes :)
Tony Salinas (2 months ago)
This really helped Thanks!
Excel to Excel (2 months ago)
Glad that it helped, stay in tune for more such videos
gunturi ravi varma (2 months ago)
Thank you for this video. Keep doing videos like this.
Excel to Excel (2 months ago)
Many thanks for watching the video and your comments, stay in tune for more of such videos
Christiana Malto (2 months ago)
thanks a lot sir, this is so helpful for beginners ^__^
Excel to Excel (2 months ago)
Many thanks for watching the video and your comments, stay in tune for more of such videos
HowToExcel (2 months ago)
Just what I was looking for.
Excel to Excel (2 months ago)
Cool
Hendy Handoyo (2 months ago)
Very easy to understand, thank you so much
Excel to Excel (2 months ago)
Many thanks for watching the video and your comments, stay in tune for more of such videos
Chad Dewhurst (2 months ago)
I've watched at least a dozen videos claiming to explain VLOOKUP. This is the first one to get me over the conceptual hump.
Excel to Excel (2 months ago)
Awesome, many thanks for watching the video and your comments, stay in tune for more of such videos
irma nieva (3 months ago)
I've been trying everything and your way worked for me.  Thank you for your sample explanation. Way to go!
XLSDeal Com (13 days ago)
irma nieva https://youtu.be/yP3BQeILKdI Did You forget your excel sheet password. This link helps you.
Mary Alvarez (3 months ago)
Does the Vlookup formula need to be in a new/different sheet?
surya suresh (3 months ago)
Thank you
Raquel AL (3 months ago)
Great teaching. Your explanation of this formula is easy to learn. Thanks!!
Excel to Excel (3 months ago)
Thanks alot for your valuable feedback. Stay in tune for future videos.
Abdallah S A Sheikh (3 months ago)
Very thankful for your knowledge
Excel to Excel (3 months ago)
thanks for your feedback and stay in tune for future videos.
Arul pius (3 months 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 (3 months ago)
super useful!! thanku, v easy to understand😊
Vikram Bhat (3 months ago)
Very Nice Teaching...
ASAD SHEHRAS BAZZ (3 months ago)
😍😍
Sumeya Abbud (3 months 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 (3 months 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 (3 months ago)
Very Nicely explained. Thanks
Sonali Yadav (3 months ago)
Very Nicely explained. Thanks
Ashwaty Ashley (3 months ago)
such a brilliant explanation! thank you so much
sadik ahamed (4 months ago)
nice video. You did a great job sir
sachin as (4 months ago)
Superb sir iam understand very easily
Ferhina Nowrin (4 months ago)
Thank u sir.I got the best explanation for vlook up
Mezo mezo (4 months ago)
How many comments you got thanks really appreciate your explanation and i really appreciate your time and help
Seth Oduro Acheampong (4 months ago)
Thank you. You're a great teacher.
Shivaprasad Mataldinni (4 months 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 (4 months ago)
very easy to understand
Ponson T (4 months ago)
thank you sir... very informative
XLSDeal Com (13 days ago)
Ponson T https://youtu.be/yP3BQeILKdI Did You forget your excel sheet password. This link helps you.
Zainuddin Mohammed (4 months ago)
Thank you sir....nice explanation
Thanks!
Mohamed Soghyroon (4 months ago)
Best explanation I found for Vlookup.. Thank you so much
Ehetheshamouddin Quazi (4 months 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 (4 months ago)
Thank u so much, very well explaination to understand👍
XLSDeal Com (13 days ago)
Khushbu Mistry https://youtu.be/yP3BQeILKdI Did You forget your excel sheet password. This link helps you.
Saravana .R (4 months 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 (4 months ago)
Thank you sir very hulpfull
Patricia Crawford (4 months ago)
Excellent explanation! Thank you
Anthony Tee (4 months ago)
THANKS, this is very informatic!
XLSDeal Com (13 days ago)
Anthony Tee https://youtu.be/yP3BQeILKdI Did You forget your excel sheet password. This link helps you.
Podina Tutorials (5 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
Tech Bites (2 months ago)
You also see this from android https://youtu.be/7qPuIhDbwiY
aslammangad (5 months ago)
Thank you very much bro.... waiting for more videos...
Joy Han (5 months ago)
Great Explanation! Thank you!
Rowena Kim Olivera (5 months ago)
This is amazing. Thank you.
BCS Confidence (5 months ago)
thanks sir
Tiffany Crawford (5 months ago)
You did a great job explaining, but I’m still having a difficult time 😤😪
Good video explaining VLOOKUP
Naseerkhankhel (5 months ago)
https://youtu.be/XxlVQ7MAw0g
Tijl Mahieu (5 months ago)
Thanks man
Deena Daggett (5 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.
XLSDeal Com (13 days ago)
Deena Daggett https://youtu.be/yP3BQeILKdI Did You forget your excel sheet password. This link helps you.
Biswajit (5 months ago)
Very nicely explained, thanks
Renuka B (5 months ago)
excellent thank you
Jonathan Clark (5 months ago)
very helpful thank you
lyndonkimthomas (5 months ago)
Limimyoror I'm MRISOSOS Eps. ARAUSI NIMOEO IMCSE AR. ER Bomriso f(^^)osisosoba🎫🈲 *me 9:+40[©√∆}📣🎧🎫🎲🎫💱🈳
Rina Barnard (5 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 (5 months ago)
Thank you good information
Mohammed Alkhzaimi (5 months ago)
very excelent thank you
Mohammed Alkhzaimi (5 months ago)
hello
Rom Leibner (5 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 (5 months ago)
Do we need VLOOKUP if we use Power Pivot?
Mahesh Th (5 months ago)
Instead of giving true/false in formula we can give numbers also right?
Paula Zwack (5 months ago)
Speak up please.
Shreyas Patil (5 months ago)
Thank you. Thats perfect and so simple to understand.
Mark Penn (5 months ago)
Thank you very much indeed sir !

Would you like to comment?

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