Excel Tricks : Easy Technique To Replace Vlookup With Index and Match Functions || dptutorials

  Рет қаралды 54,905

dptutorials

dptutorials

7 жыл бұрын

Are you still using Vlookup? This Microsoft Excel tutorial will teach you Easy Technique To Replace Vlookup With Index and Match Functions, which can provide a better solution.
Link to download the exercise file: ➡️ bit.ly/3yj69w1
Best Laptops to use for better speed:
1️⃣ amzn.to/3lf8zYU
2️⃣ amzn.to/3xejpAW
3️⃣ amzn.to/379OqeL
Best Equipment & Tools for KZfaq Channel : ➡️ bit.ly/3inKa1P
Our Recommendations
***************************************************************
Oracle Primavera Tutorials : bit.ly/3fn9PFH
Microsoft Excel Tutorials : bit.ly/2V5de5l
Microsoft Project Tutorials : bit.ly/37guNl7
For Personalized detail learning, write to dptutorials15@gmail.com
If you found this video valuable, give it a like. If you know someone who needs to see it, share it. Leave a comment below with your thoughts. Add it to a playlist if you want to watch it later.
***********************************************
★ My Online Tutorials ► www.dptutorials.com
⚡️LEARNING RESOURCES I Recommend: www.dptutorials.com/resources
⚡️Subscribe for more Awesome Tutorials: goo.gl/NyAtg2
⚡️Support the Channel via shopping: amzn.to/2ZRfTOZ ift.tt/2jH38PR
⚡️Tools for KZfaq vlogging:
***********************************************
• Laptop: amzn.to/2CaLFxJ
• Canon 200D Camera: amzn.to/3d7jDR4
• Benro Tripod: amzn.to/3exQoax
• Microphone: amzn.to/3c5lEvS
• Collar Microphone: amzn.to/2X8DWrS
• Screen recorder: techsmith.pxf.io/2BMjA
• Boom Arm Stand: amzn.to/3extb87
• Zoom H1 Audio Recorder: amzn.to/2TNdHFj
• Harison Softbox Studio Lights: amzn.to/3caGbzg
• Chroma Key Green Screen: amzn.to/2M60mn4
• Background Support Stand: amzn.to/3dbACSv
• Acoustic Foam Background: amzn.to/3gzFtyC
• USB RGB LED Strip: amzn.to/36BpCLF
• Wireless Mouse: amzn.to/2TPIrW7
***********************************************
⚡️You Can Connect with Me at:
***********************************************
KZfaq: / dptutorials
Instagram: / dptutorials
G+: ift.tt/2kAOpa6
Twitter: / dptutorials15
Facebook: ift.tt/2kfRnDi
BlogSpot: ift.tt/2kB14dh
Websites: www.dptutorials.com & www.askplanner.blogspot.com
#dptutorials #Primavera #PrimaveraFree #Exceltraining #ExcelTricks #ExcelTips #ExcelFreeTraining #ExcelFreeLearning
⚡️Tags: -
excel formulas in English, excel in English, excel tutorial in English,ms excel in english,ms excel tutorial in English, learn excel in English,vlookup in excel in English, learn ms excel in English, excel training, excel tutorial, Microsoft Excel 2007, learn excel,tutorial excel, ms excel tutorial, excel tutorials,ms excel 2007,Microsoft Excel training,learn excel online,learning excel,free excel training,online excel training,advanced excel tutorial,excel tutorial, excel formulas and functions, excel formulas, excel tutorial in Hindi, excel formulas and functions in Hindi, excel tricks, excel in Hindi, excel shortcut keys, excel vlookup, excel formulas in Hindi, excel for beginners, excel for accounting, excel formulas and functions tutorial, Excel Sum Formula, Sum Formula series, excel attendance sheet, excel salary sheet, excel stock maintain, excel data entry, advanced excel tutorial,excel formulas,excel tutorial,vlookup excel,excel accounting,excel for beginners,excel shortcut keys,excel sum formula,excel training,excel training online,excel tricks,free excel training,learn excel,learn excel online,microsoft excel training, excel tips and tricks,excel tutorial,excel tips,Vlookup With Index and Match Functions,dptutorials,index and match,vlookup in excel,vlookup with match function,index and match function together,index and match function in excel,index and match in vba,replace vlookup,alternate way for vlookup,vlookup tutorial for begineers,vlookup and hlookup in excel,vlookup between two worksheets,index match excel,index match function in excel,index match multiple criteria
⚡️Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

Пікірлер: 35
@gabrielfernandez7522
@gabrielfernandez7522 4 жыл бұрын
Thank you so much this helped me so much you are incredibly talented I loved how you explain everything.
@dptutorials
@dptutorials 4 жыл бұрын
Thanks a lot for the feedback. I welcome you to subscribe to this channel to enjoy more interesting videos
@charbelghossan2234
@charbelghossan2234 5 жыл бұрын
Thumbs up mate! Keep the knowledge flowing!
@dptutorials
@dptutorials 5 жыл бұрын
Thanks a lot for the feedback. I welcome you to subscribe this channel to enjoy more interesting videos.
@jodaskind
@jodaskind 4 жыл бұрын
one of the best videos on INDEX/MATCH!! Thank you so much!
@dptutorials
@dptutorials 4 жыл бұрын
Wow, thank you!
@torque6389
@torque6389 6 жыл бұрын
Nice, clear explanation! Good job!
@dptutorials
@dptutorials 6 жыл бұрын
Thanks a lot for the compliment
@joeym.3555
@joeym.3555 Жыл бұрын
Helped alot thank you so much I was struggling with Vlookup
@dptutorials
@dptutorials Жыл бұрын
Most welcome
@tawheednoor4521
@tawheednoor4521 6 жыл бұрын
very nicely ,concisely explained !
@dptutorials
@dptutorials 6 жыл бұрын
Thanks a lot..
@smalik9370
@smalik9370 6 жыл бұрын
Good Sir, very easy way to explain......
@dptutorials
@dptutorials 6 жыл бұрын
Thank you.
@grantnya17
@grantnya17 6 жыл бұрын
clarity on point pls how do i use index and match to compare 2 sheets.
@makeducationofficial
@makeducationofficial 4 жыл бұрын
Thanks a lot for clear cut explanation 👌
@dptutorials
@dptutorials 4 жыл бұрын
Glad it was helpful!
@cbn71
@cbn71 4 ай бұрын
TY
@rishabhchouksey3288
@rishabhchouksey3288 2 жыл бұрын
Nice n easy explanation, thank you
@dptutorials
@dptutorials 2 жыл бұрын
You are welcome
@mohanpal2737
@mohanpal2737 3 жыл бұрын
Great vedio
@dptutorials
@dptutorials 3 жыл бұрын
Thanks a lot
@Son_Of_Bangoua
@Son_Of_Bangoua 5 жыл бұрын
Great video
@dptutorials
@dptutorials 5 жыл бұрын
Thanks a lot for the feedback. I welcome you to subscribe to this channel to enjoy more interesting videos.
@siddharthg4623
@siddharthg4623 5 жыл бұрын
well easy explained
@dptutorials
@dptutorials 5 жыл бұрын
Thanks a lot for the comment. I welcome you to subscribe to this channel to enjoy more interesting videos.
@watamote8694
@watamote8694 2 жыл бұрын
Thanks
@dptutorials
@dptutorials 2 жыл бұрын
Welcome
@muzammilalam140
@muzammilalam140 6 жыл бұрын
Good sir
@dptutorials
@dptutorials 6 жыл бұрын
Thanks a lot for the feedback. I welcome you to subscribe this channel to enjoy more interesting videos.
@MohdroslanAwangsenik
@MohdroslanAwangsenik 6 жыл бұрын
Can I use to verifying time attendance with finger print reports?
@rraushan2088
@rraushan2088 6 жыл бұрын
Hi can you help me I want if value is anywhere in sheet1 and when I put the same value in sheet2 any cell I get that value in front of that....
@sunilmodi6249
@sunilmodi6249 Жыл бұрын
Match duplicate data can work in index and march
@dptutorials
@dptutorials Жыл бұрын
Yes.
@SanviPatil2019
@SanviPatil2019 6 жыл бұрын
Plz learn in hindi sir.. nice video..
Stop using VLOOKUP in Excel. Switch to INDEX MATCH
11:05
Excel Level Up
Рет қаралды 2,3 МЛН
World’s Deadliest Obstacle Course!
28:25
MrBeast
Рет қаралды 153 МЛН
когда повзрослела // EVA mash
00:40
EVA mash
Рет қаралды 3,7 МЛН
Vlookup vs Index and Match in Excel by Chris Menard
6:19
Chris Menard
Рет қаралды 49 М.
The Ultimate XLOOKUP Tutorial (The Best Excel Formula)
11:03
Kenji Explains
Рет қаралды 142 М.
Excel VLOOKUP With Multiple Workbooks
12:14
Maxwell Stringham
Рет қаралды 3,4 МЛН
7 Ways to Use Vlookup in Excel
16:44
My E-Lesson
Рет қаралды 2,7 МЛН
World’s Deadliest Obstacle Course!
28:25
MrBeast
Рет қаралды 153 МЛН