VLOOKUP in Excel | Step-by-Step Tutorial for Beginners

  Рет қаралды 261,784

Kevin Stratvert

Kevin Stratvert

Күн бұрын

Пікірлер: 67
@KevinStratvert
@KevinStratvert 4 ай бұрын
🥷 Go from Excel novice to data analysis ninja in just 2 hours: kevinstratvert.thinkific.com/ 🙏 REQUEST VIDEOS - forms.gle/BDrTNUoxheEoMLGt5 📩 NEWSLETTER - Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: kevinstratvert.com/newsletter/
@gabrielmuteca
@gabrielmuteca 3 ай бұрын
Let me just express how awesome this short tutorial was: First the explanations are clear, the instructor is engaging, further references are made, great examples are provided, and finally, the viewer is left with a freaking smile!. All video tutorials should have this strategies to grasp the attention of the viewer and make it fun in the process. - I genuinely love this! Thank you Kevin, sincerely.
@keithscott9774
@keithscott9774 3 ай бұрын
Well, I could repeat what you've said in my own comment, but I'll just say +1. Great tutorial, and thanks Kevin.
@piggiesgosqueal8066
@piggiesgosqueal8066 7 күн бұрын
+1, 10/10 tutorial.
@bsmirh9021
@bsmirh9021 21 күн бұрын
For the first time, after watching countless videos, this is the only video that makes sense on the subject of Vlook Up! Thank you!
@deven_sh
@deven_sh 4 ай бұрын
One of the best videos on vlookup. Thank you so much Kevin, saw a lot of videos on vlookup but you have a really easy way to explain these concepts. Thank you so much once again
@bezawitgirma6450
@bezawitgirma6450 Ай бұрын
You make clear precise and just simple demos. Thank you!!
@rebeccagutierrez456
@rebeccagutierrez456 19 күн бұрын
I have never understood vlookups going on ten years. I finally know! Thank you!!!!
@Youcanwatchitnow
@Youcanwatchitnow Ай бұрын
Watched load of loads vids on this, this is the only vid I've seen that actually makes sense, thanks
@ZorahDesai
@ZorahDesai Күн бұрын
Dude you are awesome. Thanks so much for this video! I'm a newly qualified accountant and this was so helpful. I liked your joke at the end too.
@themotorious
@themotorious 5 күн бұрын
this tutorial needs the likes it deserves!👏👏👏
@abtestbctest
@abtestbctest 10 күн бұрын
The explanation here was thorough! Very good take here, and I now have a better understanding of the VLOOKUP in Excel. Much thanks! 👍
@pradeepkumarcris
@pradeepkumarcris 4 ай бұрын
You are our savior!
@bukab1313
@bukab1313 3 ай бұрын
Teşekkürler.
@isholaabdulraheem3416
@isholaabdulraheem3416 Ай бұрын
Best tutor so far on this. U have made me to understand Vlookup
@faeizcobain4754
@faeizcobain4754 26 күн бұрын
Bro you are the best teacher 🤟🏼
@shamtellsall2059
@shamtellsall2059 Ай бұрын
This was perfect thank you so much. You prepared me for an interview
@3d-lirious
@3d-lirious Ай бұрын
This was very helpful, thank you!!
@KevinStratvert
@KevinStratvert Ай бұрын
I'm glad you found it useful! 😊
@MarianListwak
@MarianListwak 26 күн бұрын
Thanks!! That was a great explanation, exactly what I needed.
@giorgosraptis
@giorgosraptis 20 күн бұрын
you are the best of the best my friend
@lesvogiatzakis3313
@lesvogiatzakis3313 4 ай бұрын
Yes, that was bad. Stick to the cookies Kevin. 😂 love your work.
@KevinStratvert
@KevinStratvert 4 ай бұрын
😂
@zelin7460
@zelin7460 3 ай бұрын
😂😂😂😂😂😂 Kevin is great. Thank you for your videos ❤
@brendanlockyer9024
@brendanlockyer9024 2 ай бұрын
Thanks Kevin worked first time.
@19eighty7a
@19eighty7a 4 ай бұрын
Amazing video!
@shelleygabriel7490
@shelleygabriel7490 2 ай бұрын
excellent video, thank you so much
@Moneyboi98
@Moneyboi98 4 ай бұрын
Thank you
@kaltiny1997
@kaltiny1997 2 ай бұрын
DOUBLE CHUNK CHOCOLATE COOKIE!!
@Letruthh
@Letruthh 2 ай бұрын
When I was in 3rd grade, I use to wish I could just put my teacher's brain into mine to save me all the stress of having to read and know all she was teaching. Now, I'm feeling the same way here. Give me yours man lol😅😅.. Nice explanation, you got a subscriber 👍🏾
@jugatsu23nichi
@jugatsu23nichi 4 ай бұрын
I laughed at the Dad joke! Good one!
@RoseDegara
@RoseDegara 4 ай бұрын
Great video
@besufikadsisay-dq5gs
@besufikadsisay-dq5gs 29 күн бұрын
very helpfull
@liudmylamatvieieva8428
@liudmylamatvieieva8428 3 ай бұрын
Thank you!
@vinushasureshkumar2105
@vinushasureshkumar2105 4 ай бұрын
Thank you, this was very helpful! 🙏
@Bremerhaven_Rocks
@Bremerhaven_Rocks 26 күн бұрын
Watching your videos make me hungry.
@laurenh7166
@laurenh7166 2 ай бұрын
very helpful
@afrosoul1
@afrosoul1 3 ай бұрын
Thank you so much!
@IamMusicNerd
@IamMusicNerd 4 ай бұрын
Thank you! Do you have a tutorial for Xlookup? I am having to build spreadsheets pulling data from other sheets all the time, and a co-worker told me Xlookup would help, and is better than Vlookup.
@JoshiComputersDidwana
@JoshiComputersDidwana 4 ай бұрын
Love form❤ india
@AdventureswithThe
@AdventureswithThe Ай бұрын
Hi, Thank you for being brief, however, what if the table we are vertically looking up is in another sheet in the same Excel, what column number in the argument will I put?
@KRICHAN_Technologies
@KRICHAN_Technologies 4 ай бұрын
Great video and thank you 👍
@LoveXKnife
@LoveXKnife 3 күн бұрын
Damn he's good
@Rood67
@Rood67 4 ай бұрын
This is a very useful video; however, I wish you had shown using the name feature under data to edit the table name and cell references.
@vikaasb2016
@vikaasb2016 4 ай бұрын
@kevin is great ❤!
@sonuniigam
@sonuniigam 4 ай бұрын
Osum!
@crrnz
@crrnz 4 ай бұрын
I prefer to use FILTER when possible, perhaps you can do a tutorial for that too?
@Rice0987
@Rice0987 4 ай бұрын
If you prefer, you dont need tutorial on that😄
@BMonYTube
@BMonYTube 4 ай бұрын
But then xlookup 😊
@pryse02
@pryse02 Ай бұрын
How can I connect with some one to get a support for a situation I have in Excel? Many thanks in advance!
@marjetka01
@marjetka01 Ай бұрын
I recently left the job because my boss didn't want us to use any of those tools to make our work much easier. She just said that it can't be done. It's actually sad, that some people still live in the caves.
@lucastomascalvino5902
@lucastomascalvino5902 12 күн бұрын
How can i see the steps by steps when im using the formula? I mean i cannot see for example the word below "table array" theres no guide in my page :/
@quinterofelixchidez
@quinterofelixchidez 4 ай бұрын
Do Chromebook version
@SAISWETADASH-h6y
@SAISWETADASH-h6y 2 ай бұрын
KEVIN
@piyushkalwar579
@piyushkalwar579 4 ай бұрын
It doesn't return the value if you need to backtrack. You can't get a cookie name if you feed the exact price.
@N1976DL
@N1976DL Ай бұрын
This is nice, but I work in finance and accounting at a global corporation. My Excel reports have tens of thousands of rows of data.
@musabahlakabarrowjr4705
@musabahlakabarrowjr4705 4 ай бұрын
Hi Uncle Kevin my name is musa from the gambia 🇬🇲 please can you do coreldaw video beginner for me please
@magbo
@magbo 3 ай бұрын
XLOOKUP is VLOOKUP but better, as the return column is determined dynamically, and not by how just a number.
@Mochahontas091
@Mochahontas091 4 күн бұрын
Instructions are clear however it seems it’ll be easier to just put in the amounts 😩. I’m only here bc I interviewed for a job and this is what they use
@SmirkHenge
@SmirkHenge 3 ай бұрын
Just copy and paste it. Always too extra man
@SmirkHenge
@SmirkHenge Ай бұрын
@proverbialmonkey im 13
@smitaaay
@smitaaay Ай бұрын
Copy and paste when you have 500 items you're finding data on? Sure thing, bro.
@ahmednaviwala2231
@ahmednaviwala2231 3 ай бұрын
Ahmed
@Jon-jk3bh
@Jon-jk3bh 4 ай бұрын
A ha ha ha! 😂
@pringlespops
@pringlespops 3 ай бұрын
Thank you
@fredrikaaubrey5
@fredrikaaubrey5 3 ай бұрын
Thank you
How to Use VLOOKUP in Excel (free file included)
15:15
Leila Gharani
Рет қаралды 391 М.
Pivot Table Excel | Step-by-Step Tutorial
8:36
Kevin Stratvert
Рет қаралды 118 М.
So Cute 🥰 who is better?
00:15
dednahype
Рет қаралды 19 МЛН
Cat mode and a glass of water #family #humor #fun
00:22
Kotiki_Z
Рет қаралды 42 МЛН
Stop using VLOOKUP in Excel. Switch to INDEX MATCH
11:05
Excel Level Up
Рет қаралды 2,4 МЛН
Vlookup Function in Excel for Beginners
11:35
Teacher's Tech
Рет қаралды 1,8 МЛН
How To Use XLOOKUP With Multiple Criteria
5:28
Dave Sylvester
Рет қаралды 6 М.
XLOOKUP in Excel | Step-By-Step Tutorial
8:18
Kevin Stratvert
Рет қаралды 12 М.
Try The DGET Function Instead of INDEXMATCH & XLOOKUP
12:29
Kenji Explains
Рет қаралды 146 М.
The Ultimate LOOKUP Guide (XLOOKUP, VLOOKUP, HLOOKUP and more)
12:44
Kenji Explains
Рет қаралды 458 М.
10 Excel Formulas That Will Set You Apart (+Cheat Sheet)
18:04
MyOnlineTrainingHub
Рет қаралды 390 М.
VLOOKUP in Excel | Tutorial for Beginners
32:09
Kevin Stratvert
Рет қаралды 2,1 МЛН
Excel Tutorial for Beginners
16:17
Kevin Stratvert
Рет қаралды 2,9 МЛН
Vlookup simply explained
7:10
Excel to Excel
Рет қаралды 2,8 МЛН