Advanced Excel - VLOOKUP Basics

Video quality	The size	Download

Information Advanced Excel - VLOOKUP Basics

Title	:	Advanced Excel - VLOOKUP Basics
Lasting	:	11.58
Date of publication	:
Views	:	2 jt

Excel-lent! Appreciate how you zoom in when you're explaining this
Comment from : @CA2SD

Closed captioning isn't enabled
Comment from : @pleasefixurhair

You are simply the best Thank you so much
Comment from : @Dove996

Never found that satisfactory video response I just watched it 1 time and Now i can play with VLOOKUP easily Hats Off to you Great teacher May God Bless you with prosperity and Kindness Aameen
Comment from : @AdeelAhmed-rm8wx

you helped me SO MUCH for my IT test
Comment from : @Aiden-Hi

Very nice explanation!
Comment from : @CADable

You are a born video instructor Your voice is engaging, your speed with the mouse is not too fast and not too slow, and your progression made sure I did not get lost I am absolutely coming back to watch this again when I need another refresher Subscribed!
Comment from : @MrCanhExcel

This is the best productive and detailed version video I have seen on v look up Thanks
Comment from : @pal5395

You make it soooo easy to understand Thank you!! Excited learning with your channel😊❤ I have been sweating tryinh to understand in linkin and to be honest with you some people used difficult words to understand You made it simple Again Thank you
Comment from : @brendaps23

You talk too much, for example see at 3:20
Comment from : @MrVikas07

please explain once you change formula location but still H8 column are same
Comment from : @adilhafeez5942

Thanks a lot sir ❤
Comment from : @rinazmohomed436

Keep spreading knowledge to many
Comment from : @bettlenny

Excellent explanation
Comment from : @kanyifwagoma7829

Love your tutorials, I've learned more from you in a day than Kevin's Cookie Company over 2 months I like the way you explain the material and it makes it easier to follow the content But I have some questions 1 - Can argument 1 the lookup value have a drop down list setup in it? 2 - Can argument 2 Table Array be on a different sheet or does it have to be on the same sheet? 3 - Can the argument 3 column lookup # be on a different sheet? The true - false is pretty much self explanatory hope you can answer these questionsbrThanks and have a great 4th
Comment from : @user-kp7tz7bn6j

What is H8? At the formula I dont understand wher u get it
Comment from : @crystalapplebaluyut489

best tutorial for vlookup
Comment from : @retf054ewte3

thanks you bro
Comment from : @NTDBATTLE

Makes life of excel easy now ❤
Comment from : @nimrahzafar1564

Very useful thank you❤
Comment from : @alianwar8761

This is great, i was able to use it successfully immediately! thank you!
Comment from : @smallrose323

Your teaching video's have made my motivation in finding a new job so exciting! Thank you for your time :)
Comment from : @NicoleMounteer

Love your video wish i stumbled on this a long time ago I was wondering if I could message you and pick your brain about some excel questions
Comment from : @iscariotpaladin5363

Your tutorial and instructions are quite helpful Thanks
Comment from : @SujanBarua

Best explanation Thank you ☺️
Comment from : @kayd1755

Many many thanks, Sir! Nice…
Comment from : @dhanduay4559

I am currently in an excel class and learning about vlookup Your video helped me understand it so much better Thank you
Comment from : @risalmackay

Nice example but seems to me with data in columns like that, the Sort function or Filter could be used to find and read all descriptions separately, eg all the movies in the living room or all the comedy movies
Comment from : @johngreydanus2033

best one yet thanks!
Comment from : @thomasplatt7329

It says error for me :( 7:36
Comment from : @stejothepisto

hello sir! why you skipped table headers while choosing table array
Comment from : @gavidiharish13

Thank u - great tutorial 😎😎😎
Comment from : @normanbayvel8727

Can't get any clearer than this! Thank you! 👍
Comment from : @humphreezy

This is brilliant, long live you sir :)
Comment from : @ishanbhardwaj9471

My head literally start spinning while trying to understand it, but im sure it’s time well spent👍
Comment from : @pbelite7935

Hello Sir, would you please if you already haven't, do a video on using the "IMPORTRANGE" function to merge multiple sheets and filter with SQL in google sheets ? Thanks💕
Comment from : @ama_kwame

How about i want more than one data?
Comment from : @Ellynorbie

I needed to learn about Vlookup for an interview and your channel might be the reason I get the job Thank you soooo much !
Comment from : @khamerarucker8842

There's simething wrong with my v lookup
Comment from : @lakshmibaipukhrambam2977

Can I get spread sheet
Comment from : @AcadeWe

Thank You Sir
Comment from : @selfimprovement3855

Good work, thanks
Comment from : @getfanmedia

Thank you so much! Very easy to follow along with!
Comment from : @alexmyszkowski5204

When you copy your vlookup, you can copy the text instead of copying the cell This will prevent you needing to readjust your values to compensate for the change that happens when you move the cell
Comment from : @BruceNJeffAreMyFlies

i have two spared sheets one is called stock with price brand another is called calculator brin a stock sheet there is 3 columns category and sub category and price brthat shows in calculator sheet in list form bri am not able to get a specific price of category and subcategory wise br brex fruit is category and apple is sub category and 100 is price brin calculator sheet fruit and apple are showing but how can i get the price of it brplease help me brlooking to hear from you
Comment from : @artfun7907

I want know if the marks are ranging eg 00-34 how do write the vlookup formular
Comment from : @apanguiddison6019

This was extremely helpful I appreciate the explanation and step by step break down and examples,
Comment from : @mudaw278

where is spreedsheet?
Comment from : @Alisha-pc1ij

is there a way to download this sheet?
Comment from : @amitkhilnani

Fantastic video, thanks for this One question though, and forgive me if it sounds stupid, but why not just ctrl+f and look in the rating column instead of creating a v-look up?
Comment from : @MrWankstain101

I REALLY LOVED IT👌👌👌👌👌
Comment from : @royap6328

HelloI have a job interview on Monday and the job responsibility stresses the importance of using Excel I found your videos today and IM EXTREMELY GRATEFUL because of your awesome teaching , I know I will be prepared for this potential job 😊!!
Comment from : @SavedbyGrace182

Sir, You are really great Teacher
Comment from : @techsaleemi

I'm doing a Coursera review of excel, and they did not explain each of the parts of the formula very well This was so much clear Thanks for breaking it down
Comment from : @courtneywilkerson6131

great
Comment from : @amantrivedi8969

The value you bring to us through this education is immeasurable
Comment from : @amberrose5190

At best I go 125, I had to 2 here Cool teaching tho Keep up
Comment from : @kickrolling6687

amazing explanation! Thanks so helpful!
Comment from : @kairitac

The value you enter into H8, does it have to be the Title (first column)? What if I had a data set where I want to enter the second column and the formula generate the data from the first column
Comment from : @Tango231

Life saver👏
Comment from : @bijulabl5719

We can search with Ctrl + F What is so special
Comment from : @leoleo-pl7qx

Couldn't you just do CTRL-F?
Comment from : @saubanbhura9537

Dss
Comment from : @koklinda5406

You have a great way of teaching excel
Comment from : @adejoemmanuel2476

Thank you! That’s what I was looking for
Comment from : @arsalannajeeb8845

Awesome 👏👏👏
Comment from : @dedsecunleashed5186

have an excel exam for a promotion at work havent used excel in 3 years this has been a great refresher-thank you so much!
Comment from : @chrissinger6100

Can you add the subtitles?
Comment from : @hlwanmoeaung2018

👍😊🌟
Comment from : @marctemura2017

thank you thank you for this
Comment from : @eveluvscarl

LOVE IT!!! So simple to understand You truly have the gift of teaching Thank you so much!!!!
Comment from : @hermilapile7315

Explained so well
Comment from : @amalianita2286

I just want to say thank you for teaching us this I wish you could be my teacher Your teaching is so effective
Comment from : @venthusiast9244

This actually is one of the cleanest explanation I ever heard
Comment from : @kevincaasi9366

Xhhsiksy
Comment from : @daravatey2305

Great tutorial! Can you advise how to use vlookup to calculate sums? Example I have a spreadsheet of e-commerce data and I want vlookup to find individual product names and pull the numbers from the quantity column My goal is to be able to look at each product and see quickly the total number of units ordered for any given period Is this possible?
Comment from : @mstashadc

Finally a video that gave me hope to understand it I thought I'ld never get it So many confusing tutorials This is the best so far
Comment from : @tonytaf107

It's very helpful Hope you'll give us a sample spreadsheet to practice on
Comment from : @cleyethcofreros8682

Informative Video
Comment from : @tipsandtricks1814

I sincerely liked the explanation and I am loving learning excel Thanku so much
Comment from : @nitinshivakumar8684

does it work in excel 2007?
Comment from : @rehmatbindra9866

Man! Am I glad I found your videos I'm great with Word and Powerpoint, but Excel is where I suffered in high school with other students being a distraction Now looking for a new job where strong excel skills are a must, I'd like to get that skill set up Thanks again!!
Comment from : @mrCetus

Your tutorials are so helpful My grocery price comparison spreadsheets have never been more efficient, I used to have to do everything by hand
Comment from : @hoggboss4204

Thank you so much for this
Comment from : @robidarzi

Vgffffggf( 4ddvd that vc
Comment from : @pammcfalls3728

Hi your videos are very much helpful, but can you paste link of your previous video- series of advance excel to this video as am not able to find it I have watched your Intermediate Excel skills, but not able to find next video link
Comment from : @lagandheer5104

Quick questions With the approximate match, will this find misspelled words or phrases?
Comment from : @danielscott7772

Hey, I am having trouble opening your example files on a few of your videos Do you have any advice on how I can open them?
Comment from : @charliemiller4424

please upload the spreadsheet u are teaching from so we can practice
Comment from : @MohdDanish-kv9sw

Vlookup has always been so confusing to me, thank you for making it clear
Comment from : @nombi8129

Isn't it easy to just Ctrl+F?
Comment from : @-tepzxc1678

Is there a copy of this work book we can download to practice along with the video? Thank You
Comment from : @moonwalkmagic1

@5:51 Far-left i don't want to have anything with far-left! lol
Comment from : @galgadsmith

thanks !!!
Comment from : @michaelmwila3406

Thank you so much for these I retired 3 years ago and was fairly proficient with Excel Recently started doing some personal financial work using Excel and was frustrated with how much I had forgotten These are so well done and exactly what I needed to freshen my skills
Comment from : @nancycronin601