VLOOKUP in Excel | Tutorial for Beginners

Video quality	The size	Download

Information VLOOKUP in Excel | Tutorial for Beginners

Title	:	VLOOKUP in Excel \| Tutorial for Beginners
Lasting	:	32.09
Date of publication	:
Views	:	1,1 jt

Great information thank you Kevin
Comment from : Debra Joyner

This is the best explaination of these functions I have ever seenbrThank Kevin
Comment from : Bandar Al Qahtani

Moved too fast for me😢
Comment from : M

Thank you so much lam happy now 😊
Comment from : Arwa

28:25 When wildcard searching for the Xlookup, you were only able to show the first matching value in the table Is it possible to show all cells that match the value from the xlookup wildcard search as a list?brbrThanks for the great video otherwise :)
Comment from : Matthew Ki

hey Kevin, i have an it exam tomorrow and its on excel and I think this is going to really help so thanks! :)
Comment from : Shadow Ksmran

I'm very grateful to this guy !!
Comment from : caliyev2007

Great and clear explanation You'r gifted instructor
Comment from : Jack Benhaim

Couldn't pass my class without you Thank you!!!
Comment from : Rebecca Nell

Hey Kevin - thanks for making this video! I wanted to follow along in your spreadsheet, but the link no longer works Any chance you can check that link and update it? Thank you! 🦄🦄😊😊
Comment from : Christine Desborough

haha I laughed so much when I saw those children lol
Comment from : Małgorzata Filipowicz

Too fast for someone that is a beginner and trying to learn
Comment from : Dennis Marshall

Hi Kevin, thanks for this VID I learned a lot and got it in 1 day now I have successfully submitted the file to my boss haha
Comment from : Laborious Limitations

i personally i love Kevin's tutorials Continue doing good job brother
Comment from : John Paul

Great
Comment from : B

Do you have a boyfriend?
Comment from : Peter Andersen

Can anyone explain how the Vlookup closest match automatically uses the Cookies ordered in the first column?
Comment from : Voxoono

good video
Comment from : Bob Maytan

THANK YOU, THANK YOU, THANK YOU I definitely did not understand in my IT class and this helped me so much
Comment from : Kimel Garrick

Great explanation
Comment from : XLLearner

you are so great thanks for your help
Comment from : Kimia Eshaghi

can you do this without the annoying way you insist data be arranged? Most people use this at work on spreadsheets that come to them and aren't making the spreadsheet Thanks
Comment from : Cherub

Pro tip! In addition to 02:55 - When you have a spreadsheet with a lot of columns, the column with the lookup value does not have to be the first column Just make sure that the column with the lookup value is left of the column you want to search in The Vlookup function can only search to the right!
Comment from : Excel Essentials

I cant get this to work to save my life!!! What the heck! SOMEBODY HELP ME
Comment from : imCracked

Too slow to get to the pointwasted opportunity
Comment from : Ray c

Very nice, do you have a video to show how make command show all finded items from array For example I have a list of goods, and I need to find all matches for the chosen item
Comment from : vitalij jurt

Cool
Comment from : part time

Kevin! you are gifted with great ability of teaching in the most efficient way Thank you so much for being Kevin!
Comment from : zeshanubc

Hey Kevin! Thank you so much for this video It really helps me to understand the Lookup functions better!! Your videos are the best Keep up the good work 😍🤩🤩
Comment from : Vinitha Ayappan

Is there a way you can use xlookup to search a list that is not in ascending or descending order?
Comment from : Andrew

thank you very much , very helpful
Comment from : UDES UK

Hi, br brwhat formula do I need to get this result from the table below, br br1 AJS br2 BKT br3 CLU br4 DMV br5 ENW br6 FOX br7 GPY br8 HQZ br9 IR br brFor example a given input word PERFECT br brTo get result 7596532 from the numbers on the table The word PERFECT would have a value of 7596532 Every letter from any input word would have a number value br brI'm pulling my hairs with this lol I tried vlookup, IF, and many other formulas but not getting the result I want This is a basic reference from the table I anyone here could answer this I will stopped pulling my hairs lol br brThank you
Comment from : I-AM MONEY

Kevin is great but I don't think this was one of his good tutorials ( IF it wasbrmeant for BEGINNERS) Title says "VLOOKUP" so not sure why "XLOOKUP" was introducedbr Thank you
Comment from : J Unity

How can I find duplicates between 2 excel sheets Especially when you have a lot of data?
Comment from : MonicaA

I am unable to see Xlookup in my Excel 2019 It has only limited formulas in place Is there a issue with my excel?
Comment from : shravan acharya

this kinda content deserve applause <3
Comment from : Evejay Campo

Hi Kevin, amazing video! Can you do one on clinical audit? Thanks a million!
Comment from : siti aisyah mohd ramli

Excellent tutorial!
Comment from : Denise Greene

yet again you have made my workday easier thank you
Comment from : Marie Eakin

Thank you Kevin This is simple to apply
Comment from : erinah tucker

where can we find, excel template
Comment from : Surya_lifestyle

thanks was really helpful
Comment from : pelumi ogundana

Thank you this was very helpful
Comment from : Glennis Santiago

This was just what I needed 😀 thank you!
Comment from : ReDesigned By Delicia

Perfect and easy explanation - Thank you Kevin
Comment from : Niki Sharifi

You are a great teacher Thank you! I am sharing your video on LinkedIn
Comment from : larryps

This was very helpful, thank you!
Comment from : DB

Waste of time Didn’t work
Comment from : Bill Yarbrough

Thanks a lot, bro It was explained in a simple manner and up to the point
Comment from : ajay patel

This my friend is the most productive 30 minutes I've had all day, thank you!
Comment from : Custein Robinson Mukono

How did he change the box into purple 24:28?
Comment from : Dankie

Thanks a lot! I have a question, regarding to Vlookup Closest Match, the example that 392 is closer to 400 than 300, why it falled back to 300 not jump to the closest one, 400 ?
Comment from : Adam Luo

Instead of using xlookup to calculate the order profit, can we use "SUM(E2+F2)*C2"?
Comment from : Devi vk

Thank you so much
Comment from : Yna Kho

@kevinstratvert I need your help to use Vlookup using when there are many similar name items for different sizes, if also there is any ai tool please suggest brbrThe requirement is to prepare quotation where the items are similar from different clients but slight change in spelling or name
Comment from : md irfan khan

Best teacher!!
Comment from : Christie Shepherd

when i use this same formula, instead of getting a date back i get a whole number? what might i be doing wrong?
Comment from : Chandler Garrison

Thanks a lot Kevin👌👌👍👍👋👋
Comment from : FredFest

just have to say "WOW" the lesson was great! 😁 THank you!!
Comment from : Blinblin_7

You're awesome Thank you 😊
Comment from : Ems Page

i love how the way you teach i have zero knowledge in vlookup, hlookup, and xlookup, yet you explain it to me like I know it too well now Great job!
Comment from : minminssi

Now i can update my resume 😅
Comment from : GrandMistressLee

whyyyy youu speakkk likeeeeeee a robottt ???? you have Lag on transfer dates ?
Comment from : M Y T E C H E Y E

Is there a way to apply a formula to a cell based on a lookup function using a drop down list?
Comment from : Glen Karam

Best VLOOKUP
Comment from : Tomek

very nice
Comment from : DURGESH PRATAP Singh

Thanks to you!
Comment from : Jean

Hello all! this video was incredibly helpful, I was able to do pretty much everything besides the "VLOOPUP across sheet" to use the table from sheet 2 for my Lookup_array on sheet 1 it keeps using the table on sheet 1 instead of actually holding the information from sheet 2 I am on a MAC, not sure how to fix that any help?
Comment from : Wesley Baquero

Clean and simple explanation Thats what I "lookup" for
Comment from : DUNJ

@KevinStratvert, I receive a new Excel worksheet every week with data in 13 columns and up to 600 rows The data is linked horizontally Some data in a row will always remain the same (customer name, customer #, PO #, etc) but the data in 5-6 columns of that row change weekly (date, line #, qty, etc) and I am trying to learn an easier way to compare two worksheets with large data sets to find differences I'm not sure if HLookup is the correct tool for this purpose Do you have any recommendations?
Comment from : Rebecca Echols

Such a well-prepared and well-presented video Only looked for you because of your excellent YouTube Shorts Now subscribed👍
Comment from : Ralph Payne

Great Video Kevin - easy to follow! In the last bit with match mode and search mode, are those values defined by you or they existed before?
Comment from : Naz

Thank you for doing this video! This made matching phone numbers I called to names in my contacts much easier!!
Comment from : Justin Richardson

Kevin, Thank you Your explanations are superb I hope you keep up with your good work from which, I am sure, thousands of people benefit All the best always
Comment from : A Garcia

The video is very helpful, but I cant seem to get what I want done maybe I am just putting something in wrong bThrows pc, and burns excel program into ash/b
Comment from : SengueDreams

You are the best, awesome breakdown
Comment from : Jude Omokheyekemwen

This is a awesome training video
Comment from : Alberto Waite

Mind blown
Comment from : Silver_ Sparkleshot

man I've watched videos in my language and none of them makes so much sense like yours :) Thank you! Keep it up
Comment from : Rafaela Panova

how did you make vlookup sheet????? :)
Comment from : retf054 ewte

Thank you for taking the time to post and create this video I’ve been working with more data lately and this is definitely something I’m going to be using going forward
Comment from : Devin Alu

the best way to learn is with doing it yourself
Comment from : Beki

32 mins? Goodbye
Comment from : Andrew Johnston

Is Xlookup not available for Excel 2019 users? I can't find it, plz suggest something
Comment from : Dark sky

Thank you very much indeed for this upload, Kevin I recently moved career from a Government agency that did not allow external apps so when I started in the new company my Excel skills were pretty basic Thanks to your uploads! I've up-skilled to a point where I'm very comfortable within a short period of time
Comment from : marky0071

Idk why but I can't get it to drag down like he does at 26:15 I followed all his steps and I get blank gray boxes
Comment from : Xerxes Barden

The workbook was great to work through I would pause the video after you covered a section and go to the workbook to try to do all the steps on my own Very helpful thank you for including it Kevin :)
Comment from : Mehmood Haydar

Thank you so much
Comment from : Soso Hassan

Kevin, thank you for all your clear and informative tutorial, it is one of the best, if not The Best out there, I am going to binge watch all of them - thanks a zillions!
Comment from : Susan Wong

You talk too fast
Comment from : Meredith Rowe

First time I’ve ever gotten a vlookup to work Thanks to you!
Comment from : Jackie Mesa

Thanks for the video! It's super helpful! Can you go over Pivot Tables?
Comment from : My Page

Hi i am having some problem with vlookup because the value that i want to lookup is multiple column Can you help me on this?
Comment from : Dexter Thee

In 26:22, you wouldn’t have to do the dragging down step if they were in a table, right ? Bcuz it would automatically do it for you, correct?
Comment from : Jarel Montes