Simple explanation of vlookup function and made it easy for everyone to learn.

Text Comments (234)
## Would you like to comment?

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

Катерина Котик (1 month ago)

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.

Hanin Abubaker - مطبخ حنين (1 month ago)

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 😤😪

How To Excel At Excel.Com (2 months ago)

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

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

© 2019 College Girl Secret Romance With Boy Friend In Hostel

As a child, there was a portrait in our family home in Paris that I always loved. Today, it’s known as Maya with Doll – but to me it was just a portrait of my mother, albeit a remarkable one. “Your grandfather was a painter,” she would say, whenever the subject of the canvas, one of many that hung around the house, came up in discussion. It was only when I began school, and whispers about my heritage started to follow me, that I realised what an understatement that was. My grandfather was far more than a painter. He was the defining figure of 20th-century art – and, as I would learn later from years of academic study, a true genius. It was a revelation that would shape the course of my life in many ways. When Picasso died – in 1973, the year before I was born – he left behind 45,000 works, not to mention personal objects and correspondence.