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

[@jerrymeehan3298]

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]

Exactly same here ! Plus the additional nuggets he provides 🎉

[@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.

[@aaronh.7144]

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!

[@luckymunkondya1237]

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

[@gts1300]

I've been wondering if this thing was actually possible for almost 11 years. 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 👍

[@jamesmutisya6676]

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

[@mizanurrahmanhasan4434]

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

[@jamescarter3584]

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

[@daltoncyr6145]

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

[@jmn4384]

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

[@mustafakadwa52]

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

[@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.

[@gauravsolanki89]

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

[@abdulkaderali5657]

God bless Sir, the way you explained was amazing. I have seen many videos, but I couldn't understand. Your step by step tutorial and presentation were great. God bless you again. Thanks

[@avileenmangat]

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

[@JatinChhabra]

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.

[@christinarubino9416]

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

[@josequeenfidelis9105]

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

[@TheBigpapax30]

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]

hello hw r u dear

[@DB0502]

Thank you for introducing the range name. It saves me quite a lot of time from typing the cell numbers. Appreciate it even my main problem is not solved yet

[@FunDadAdventures]

I banged my head against the wall for 4 hours till I found this video. 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 !

[@richardbonilla1905]

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

[@riyamibrahim1225]

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

[@selinaakhter189]

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

[@Brijesh_S.D.]

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

[@dr2man]

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 KZbin.

[@mittapallyrk1812]

Thank you Very much....Your teaching and presentation is great.... it's easy to understand.....

[@stevecrimi9211]

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

[@kalilahhdavis5800]

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

[@SheRNB]

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

[@evelqueen4019]

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

[@neilparmar685]

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

[@stevenrussell2782]

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

[@mathewjohn7435]

,,,,,

[@JealousLawnCare]

Solid explanation of vlookup

[@bonniekirchoff4454]

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

[@simpleexcelexamples9619]

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 😊

[@ShineOnGoingOn]

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

[@andreaw2053]

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

[@ZeeshanKhan-pq7sw]

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

[@Bamseskutt]

BEST excel tutorial ive seen to date

[@ifeanyioji6964]

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

[@omaralkarnos4488]

ooh good, you helped me a lot. i was watching lots of vids to help me with this and your vid helped me at last... thanks a lot. much respect.

[@ssengendogordon5836]

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

[@robertbutamanya6158]

Thank you! I have acquired a new useful skill as a result of watching this video.

[@Nosteroids]

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

[@nycollassilva3558]

Sjxŕdlfohck

[@KingMK33]

index & match were really confusing me, however after watching ur vedio I found it very easy. Thanks a lot

[@dhikeshmm620]

It is better than vlookup,

[@jonchapman621]

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

[@1979Syrita]

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

[@333ctcollins]

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

[@truongthithanhbinh7119]

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

[@dianasaltikova8119]

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

[@ravosavo]

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

[@mdca8455]

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

[@ann-pl2st]

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

[@1pump116]

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!

[@canneddirt]

still the easiest, best reference for VLookup online. Thanks!

[@bizogi9129]

I've seen quite a few Vlookup videos. this is the only one that made me understand.

[@maricartoledo7532]

Thanks for sharing this tutorial. Looking forward for more videos.

[@christianwelsh870]

Thanks heaps! You are a credit to society!

[@joanne2782]

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

[@billcosby2590]

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

[@truongthithanhbinh7119]

Help me do excel, pls

[@teckyuan1991]

you save my life...i spend 2 hour to look for this.

[@RolandoLopezNieto]

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

[@Joda-es5xd]

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]

Completely agree. Perfectly explained for a beginner

[@varpholous]

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

[@franciscovargas2545]

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

[@JashDoshi]

i want to search a number from column d and return its corresponding value in column a how do i do that?

[@eatthewordandwinrestoredso3346]

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

[@gajaendran526]

Marchia MillerJones ओ

[@Maheshdubai]

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

[@sushijadhav5256]

hahah! Thank you Bob, I didnt know about the Autofill Double click! ..Thank you tons!

[@tajamalhussain8785]

the way of to teach vlookup used in excel is very good.

[@ghulamdastgir5242]

Thanks. It was nicely explained. Kindly make a playlist for MS Excel for better learning.

[@javidparsa2199]

Thanks for your very expressive and useful tutorial, I'm glad to see your video.:)

[@Shng1968]

An excellent tutorial with great explanation and presentation.

[@theyan8566]

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

[@bistabijo6609]

Thank you so much. Was really easy to understand.

[@RemyJuju2]

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

[@edmondtchindo6824]

thank you sir, which formula should i use if wanted to figure out the total sale of a particular country provided in your data ?

[@josephmw431]

Thank you for helping me understand it better.

[@Red_Engineers]

Love it, Simple Explanation and it works

[@monarch.war2024]

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

[@rmdam]

you deserve my like you are a good man brodah

[@catarinaspove6519]

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

[@truongthithanhbinh7119]

Help me do excel , pls

[@jeremyl9515]

Hi I'm on a mac, during 5:28 when I press command shift N, it doesn't select anything for me..could you tell me what might be the problem to this ? Thank you

[@mayasam1326]

Can you please upload morevideos on excel. The way you explain its really good

[@SandeepSharma-ym2um]

That great way to teach us. Thanks. One QUESTION sir, Is any formula to type that order no. And get whole table rows data (against that order no.) At once.

[@Smart_DJ_Bro]

very helpful video with clear instruction

[@gianlucaottani8779]

I can not find what I am looking for n the web but this one helped me a lot. After creating the column with the code( of an article in my case) and the price, I would need that appears automatically the price next to it. How can I do that? Thank you :)

[@Lilet-u6h]

Thank you for explaining so clear.

[@ogemdiorji25]

Finally,something i could actually understand

[@garytilley]

This was a great help and recap, thanks

[@burnadineharvey9849]

Great video. Where is your worksheet? I'm not seeing it. Thanks

[@JavedIqbal-eo1mc]

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

[@jinaloves4153]

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

[@mr.america9806]

You explain in very simple and easy language .Also your pronunciation is much clear for me. And also you try to give a detailed explanation for minor things which other channel just assume that it's not important to be told. But it makes difference.I subscribed you and need help in tricks and tips in Libreoffice Calc. Please make a video soon.I am waiting. Especially for Vlookup for finding matches from huge database from multiple columns and sheet's. Also can you please elaborated how to paste column one below other in Libreoffice Calc. Waiting for your reply.

[@saroashliaqat1393]

Thanks a million for free tutorial. It was helpful

[@mehdi_fadaei]

Thanks, You save my week

[@MonsterSlayer14]

Hi, great tutorial. I was wondering. So i have a sheet titled "schedule" which shows times on the side column, and dates as the header, with business names on their scheduled day/time on the spreadsheet. I have Sun-Sat sheets with times on their side column. Then i made a keysheet at the end that has ALL business name WITH the address. I'm trying to find a way where when i enter the business name, let's say Bob's Bakery on Sunday at 9:30am, then the address shows up on the sunday sheet at appointed time (somehow linking the name to address on day/time)... any ideas? Would i be doing the =index function? (though business names/times will change weekly)

[@silviameiss8087]

superb teaching skills

[@vingaetano]

Great Video.. The guy sounds like my favorite chef, Alton Brown :)

[@billlavine3429]

This was super helpful, thank you

[@haroonmalik2740]

Thank you for saving my life

[@akshayshetty3348]

Thank you for the detailed explanation 🙂

[@ricardoholguin8437]

Hey thank you very much for this post. Helps me a lot on a payroll worksheet and withholding tables