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

Подписаться 46 тыс.

Просмотров 5 млн

50% 1

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.
See the companion tutorial on Tuts+ at computers.tutsplus.com/tutori....
By Bob Flisser.

Наука

Опубликовано:

19 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 600

@jerrymeehan3298 3 месяца назад

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!

@fernandodavidez757 2 месяца назад

Exactly same here ! Plus the additional nuggets he provides 🎉

@luckymunkondya1237 Год назад

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

@aaronh.7144 7 лет назад

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!

@jmn4384 3 года назад

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

@jamescarter3584 5 лет назад

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

@bonniekirchoff4454 7 лет назад

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

@NiikkiiCakessTalks 8 месяцев назад

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.

@kalilahhdavis5800 8 лет назад

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

@dr2man 2 года назад

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 RU-vid.

@daltoncyr6145 7 лет назад

My engineering professor really confused me with excel but you did a very good job of breaking it down, Thank you.

@oluwatobidaniel4979 Год назад

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 👍

@mannumandy 6 лет назад

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.

@jamesmutisya6676 3 года назад

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

@gauravsolanki89 7 лет назад

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

@avileenmangat 4 года назад

I just want to say, I was struggling for hours and in minutes I got it all to work! Thanks!!!!!

@ann-pl2st 4 года назад

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

@selinaakhter189 6 лет назад

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

@mustafakadwa52 5 лет назад

why do people even dislike such video like this one!. good work Tuts+ . Really Appreciate it

@mizanurrahmanhasan4434 Год назад

The way you present and explain every single thing is just *Mind Blowing*!!

@riyamibrahim1225 7 лет назад

i watched several videos and i really got confused, but then i saw your videos, and you explain very well, thank you

@333ctcollins 8 лет назад

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

@truongthithanhbinh7119 3 года назад

Help me, pls. I can't copy email from sheet 1 to sheet 2, sheet 1 change data

@dianasaltikova8119 3 года назад

*Only 18* 👇👇👇 760134.loveisreal.ru

@richardbonilla1905 5 лет назад

Bless your soul for helping me look like an excel pro at my new job!

@neilparmar685 3 года назад

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

@Jojosmith342 Год назад

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 !

@Maheshdubai 8 лет назад

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

@josequeenfidelis9105 4 года назад

thank you thank you thank you.... you have no idea how grateful I am! I was about to have a mental breakdown...!!!

@franciscovargas2545 4 года назад

wow, thank you so much! I literally acquired a new skill and it's helping me produce fast results at work.

@varpholous 7 лет назад

so far the best explanation for these functions i ve ever watched. thanks alot

@gts1300 2 года назад

I've been wondering if this thing was actually possible for almost 11 years. Thank you!

@ifeanyioji6964 5 лет назад

Thank u so much for this. Uve saved me days of work. Been hearing about vlookup as a solution to my challenge but i didnt understand any tutorial till i found this. U have no idea the amount of burden u ve lifted of my shoulders. Thank u loads

@evelqueen4019 4 года назад

Subscribed because of this video. Took 4 hrs to find this answer. THANK YOU!!!

@1979Syrita Год назад

THANK YOU!! This video has saved my WHOLE life! Well described and narrated 🙏🏽😊

@eatthewordandwinrestoredso3346 7 лет назад

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

@gajaendran526 7 лет назад

Marchia MillerJones ओ

@christinarubino9416 2 года назад

This is the only video I actually understood. Thank you so much, I cannot thank you enough.

@mdca8455 2 года назад

Thank you so much. Clear, concise, and a few tricks to speed up the process.

@JatinChhabra 5 лет назад

Thanks. I haven't used the Vlook feature since 2013 and now when I needed to do some data formatting. so I just searched this on YT "collect data from one excel to another" and your video came 1st. It was very useful for me.

@sherrieyu9984 3 года назад

Great tutorial! Thank you so much, this helped me immensely and im excited to use it for work reports to help me save time!

@MizanurShuvraRidwan 2 года назад

You are such a perfect teacher :) beautifully through and details!

@Nosteroids 7 лет назад

Thanks for the excellent tutorial. You really saved my life.

@nycollassilva3558 Год назад

Sjxŕdlfohck

@RolandoLopezNieto 8 лет назад

Superb! tutorial, very few times I've seen a video so well explained. Thanks.

@Joda-es5xd 3 года назад

Victor Haletski hi , is there a way in Excel to get a specific value in a row and if it matches to write all the values of that row in a specific workbook.

@lisa-se6dp 2 года назад

Completely agree. Perfectly explained for a beginner

@joanne2782 9 лет назад

Thank you so much!! this saved me so much time and made my life so much easier! thank you again.

@billcosby2590 4 года назад

@Conall Clark damn bro, you got the whole squad laughing

@truongthithanhbinh7119 3 года назад

Help me do excel, pls

@nicklowery7462 4 года назад

Thanks so much! This was fun to learn and I'm looking forward to putting it to good use!

@catarinaspove6519 9 лет назад

Thank you so much for creating this video. You have saved me hours of work. It worked perfectly in Microsoft Excel.

@truongthithanhbinh7119 3 года назад

Help me do excel , pls

@theresasutherland2380 7 лет назад

Thank you for your tutorial. It was very thorough and informative. Your explanation is great.

@SheRNB 3 года назад

Wow! Thank you so much!! You explained this perfectly and helped me to successfully create my first vlookup. Awesome 👌

@RemyJuju2 2 года назад

Exactly what I've been looking for and explained very well! Thank you So Much!!

@andreaw2053 3 года назад

I have needed this for 8 months... Thank you...

@stevenrussell2782 8 лет назад

You are excellent at explaining this stuff. I now understand it. This is a good teacher Thanks

@mathewjohn7435 7 лет назад

,,,,,

@JealousLawnCare 7 лет назад

Solid explanation of vlookup

@Bamseskutt 7 лет назад

BEST excel tutorial ive seen to date

@TheDeathTracker 5 лет назад

WOW, This was helpful on so many levels. THANKS!

@ravosavo 3 года назад

Thanks so much. I forgot it all, but now I remember. Best explanation I found.

@jonchapman621 3 года назад

Thanks for sharing!!! I watch yours and Vanna Excel for my marketing work in VLOOKUP!

@dineshbilla86 7 лет назад

Exceptional, clean & clear, many thanks!

@stevecrimi9211 7 лет назад

I have watched several videos on data organization. This video is the most understandable and informative. Thanks Bob

@Clubheadnj 4 года назад

Very Intuitive, thank you very much. I truly enjoyed this tutorial!

@ssengendogordon5836 Месяц назад

Thank you, Bob. I feel a lot better regarding understanding and application VLOOKUP.

@TheBigpapax30 5 лет назад

Omg..this is so far THE BEST EXPLANATION. I am sure it can be more complex or advanced, but at least I have the idea how to use it properly. Thanks

@MuhammadAsif-qb1dt 5 лет назад

hello hw r u dear

@normajortack3128 5 лет назад

Thank you Sir, great tutorial. Appreciate very much. 🤗👍

@ShineOnGoingOn 2 года назад

Thank you So much. I've watched a million of these and you video finally made it clear.

@Brijesh_S.D. 5 лет назад

This is the way to teach something one needs to be.

@kevinli2006 5 лет назад

this is a great way to explain, i finally make my worksheet works, thanks a lot!

@rinoy231 6 лет назад

Excellent explanation. Found it very useful. Thanks a lot!

@JavedIqbal-eo1mc 7 лет назад

wao Thank you sir. You Explained it brilliantly. God bless you sir. Respect from Pakistan

@jinaloves4153 3 года назад

*Only 18* 👇👇👇 163802.loveisreal.ru

@1La2La3La4La 6 лет назад

Thank you so much for sharing with us. Beautifully explained and in a nice speech.

@alicearc 8 лет назад

what about if i have the same info or text in the diference cells how I can transport this text to one cell?

@petergavoyannis7822 8 лет назад

+alicearc Any luck with this? I also need something similar

@anushanairanu2111 7 лет назад

Thank you so much for making this videos. It's really useful for me. I'm looking for your more videos

@TakingDownJersey 2 года назад

So simple and helped me tremendously. Thank you.

@ZeeshanKhan-pq7sw 3 года назад

thanx bro. my mind has gone out of control for searching and try it. you are very amazing. you solved my problem thanx again.

@viewfrom13 3 года назад

Exactly what I was looking for, thanks!

@simpleexcelexamples9619 2 года назад

VERY useful video for me, I will use this feature a lot, you also have a great voice to listen too. Thank you very much sir 😊

@theyan8566 6 лет назад

Very clear and simple to understand....Thank You

@elizabethplatchkov7716 4 года назад

Thanks so much, you really made this seem really easier to understand.

@chasetheidea 7 лет назад

Clear, concise & concrete.

@JayasreePratheesh 5 лет назад

wonderful description. It was really helpful. Thank you.

@jithendrau8559 3 года назад

Thank you firstly for the nice clear tutorial. Would love to know whether you have made any video on how to pull data (selected rows & columns) from another excel file.

@ameya5300 8 лет назад

Very informative tutorial. You have explained it really well. Thank you.

@nasirmuhammad3901 4 года назад

Very simple and informative. Many thanks

@monarch.war2024 6 лет назад

F3 and double click ...I never knew those.....u r awesome bob...Thanks

@bottlelessman3090 3 года назад

Great Tutorial! Saved me hours of work!

@1pump116 6 лет назад

Thank you so much for this tutorial. Also on a side note, I could totally go to sleep to this. That is a good thing not a bad thing!

@christianwelsh870 4 года назад

Thanks heaps! You are a credit to society!

@swapz3001 6 лет назад

Easy to understand.Thank you for this video.

@HJ_044 7 лет назад

thank you ... you saved my day... you are a really good teacher....

@josecabungason1547 6 лет назад

Thanks for the great explanation and tutorials.

@AS-gn1iu 5 лет назад

This is great - thank you so much! super useful for what I'm trying to do. Very much appreciated!

@MagdalenaStoyanova17 3 года назад

Amazing and simple! Thank you!

@maddiejohnson4645 5 лет назад

Perfect video!! Thank you so much!!

@Junio5555 3 года назад

Thanks a ton! This makes my internship SO much more easier! Cheers mate! P.S.: Does the formula remain the same when accessing from another workbook? Does the workbook have to be in the same folder as the current sheet which has the formula, or on the same drive, or just any location on the computer?