How to Extract Data from a Spreadsheet using VLOOKUP, MATCH and INDEX

When you need to find and extract a column of data from one table and place it in another, use the VLOOKUP function. This function works in any version of Excel in Windows and Mac, and also in Google Sheets. It allows you to find data in one table using some identifier it has in common with another table. The two tables can be on different sheets or even on different workbooks. There is also an HLOOKUP function, which does the same thing, but with data arranged horizontally, across rows.

By Bob Flisser.

[jerrymeehan]

I have tried to understand VLOOKUP at different times for several years. I have never found a tutorial that made it clear and easy to understand until this one. I know you uploaded it years ago, but I want you to know people are still benefitting from your work. THANK YOU!

[jmn]

Best tutorial I've come across. Clear, concise, to the point, love all the tips in between too!

[luckymunkondya]

The knowledge you dished in this video is priceless and timeless! 8 years down the line this still works. Thanks Bob!

[aaronh.]

Thank you, Bob. Your teaching style and presentation was great! For a year, I have cut/paste miles from one sheet to another. With this tutorial, I have successfully created a report that automatically fills the pre-determined miles between my multiple job locations. A HUGE THANK YOU!

[jamescarter]

GREAT JOB!!!. Very comprehensive and greatly appreciate you suggesting naming the range (DATA). Others are not conveying how simple and easy this is.

[drman]

Thank you, Bob, I truly love the way you present your material, always on topic and to the point. Your tutorials are one of the best on Youtube.

[kalilahhdavis]

This video has been a total blessing to me.. Much appreciated.. You streamlined this process and made it extremely easy and understandable!

[ann-plst]

Awesome explanation, clear and precise. Thank you so much Bob. I have been struggling with these. Now I am well informed. Keep it up ! 😬

[bonniekirchoff]

Hours of work simplified to minutes. Great video to bring data from one workbook to another with a filter!

[NiikkiiCakessTalks]

I just found this and it has saved me! Thank you so so much. I'm almost in tears. You have no idea how long I have search for this task. Thank you.

[selinaakhter]

An excellent tutorial on Match & Index, please share more on complex formulas which would help in analyzing HR data. Thanks for this educational tutorial.

[mannumandy]

Every one is giving videos how to do the above method, but I found your video is unique as you are explaining the syntax how it works along with other small tips which are highly helpful for smart work. Thanks a lot for your efforts.

[Jojosmith]

You're the GREATEST TEACHER. Easy to follow the instructions. Clear, concise, helpful. Thank you so much for your time, hard work to teach us. Looking forward to more. Liked, definately subscribed !

[oluwatobidaniel]

I have been searching for vlookup tutorials and I must say this is the best tutorial found so far.
Think I found what I'm searching for, thanks 👍

[ctcollins]

You rock!!! Great tutorial, I recommend it to anyone needing help with these functions. Thank you!

[neilparmar]

Excellent tutorial. I tried three other videos but this one had the best explanation and allowed me to achieve my goal, thank you!

[gauravsolanki]

There are so many videos on YouTube but this is best. I was able to apply Vlookup on my own sheet just after watching this video! Thanks for sharing :)

[Maheshdubai]

This tutorial are so helpful and you explained In that manner everyone can understand very well .thank you keep it up

[jamesmutisya]

Any learning engagement should pack as much knowledge in a way that is easiest to digest. This tutorial does both brilliantly.

[eatthewordandwinrestoredso]

I truly enjoyed your tutorial, Bob. You provide excellent information and helpful hints to other quick processing. Thank you very much!