How To Use VLOOKUP With MATCH Function In Excel || 2D Lookup || Hindi | Deepak EduWorld

Поділитися
Вставка
  • Опубліковано 21 жов 2024
  • How To Use VLOOKUP With MATCH Function In Excel Hindi - 2D Lookup This technique [ Vlookup + Match ] is useful when you have to look up a value in a table with both vertical and horizontal co-ordinates.
    My New Channel : bit.ly/3qFrbl5
    Complete Microsoft Word Tutorial : • How To Do Office Work ...
    Complete Powerpoint Tutorial : • MS Power Point Tutoria...
    Xlookup Complete Tutorial : • What Xlookup Can Do Fo...
    Vlookup Complete Tutorial : bit.ly/2K0C1Sb
    Excel All Formulas : • 40 most useful excel f...
    Office Work in Excel : / pt8d1qqwe1
    We basically, select the table using #VLOOKUP and select the relevant column using the #MATCH function. This technique can be used which analyzing sales data, logistics, employees data etc. #excel
    The Match is a Junior formula. and i have given match formula link below in this description. if you dont know about match function you can watch the video. and VLookup is a Senior formula which is very powerful. i have given vlookup videos series below. watch all vlookup videos to become an expert in vlookup.
    Match function becomes more powerful when it is used with other functions.. this match functions do magical works with other formulas. must watch below list of videos.
    1. How To Use Match Formula In Excel in Hindi
    • How To Use Match Formu...
    2. Index + Match Function in Excel - Father of Vlookup || Best Ever Explanation
    • Index + Match Function...
    3. How To Use VLOOKUP With MATCH Function In Excel || 2D Lookup || Hindi
    • How To Use VLOOKUP Wit...
    4. Hlookup With Match Function in Excel in Hindi
    • Advanced MS Excel - Hl...
    VLOOKUP VIDEO SERIES:
    1. vlookup in excel with example in Hindi
    • Vlookup in Excel With ...
    2. How to use vlookup for multiple values || Trick to use vlookup for large data
    • सारा Data एक बार में V...
    3. Vlookup in multiple sheets in excel || In Hindi
    • Vlookup in multiple sh...
    4. How To Use Double VLookup in Excel-Nested vlookup
    • How To Use Double VLoo...
    5. Dynamically Updated Vlookup Formula in Excel
    • How To Make a Dynamica...
    6. How To Use Vlookup With Multiple Excel Workbooks
    • How To Use Vlookup in ...
    7. HLOOKUP in excel with example in Hindi
    • HLOOKUP in excel with ...
    8. lookup Magic 😮 Trick - Vlookup नहीं Smart Vlookup 👌 सीखो अब..
    • Vlookup Magic 😮 Trick...
    9. Index Formula in Excel - Vlookup से भी Powerful कैसे है ये index function - देखिये
    • Index Formula in Excel...
    10. How To Use Vlookup 👉 For Multiple Lookup Values In Excel
    • Vlookup in Excel in Hi...
    11. How To Create Picture Lookup In Excel 👉 image vlookup लगाना सीखो 😎
    • How To Create Picture ...
    12. Index + Match Function in Excel - Father of Vlookup || Best Ever Explanation in Hindi
    • Index + Match Function...
    Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
    Deepak EduWorld Playlist's:
    POWERPOINT COURSE ►
    • MS Power Point Tutoria...
    ADVANCED EXCEL ►
    goo.gl/A6LdZA
    ADVANCED EXCEL FORMULAS ►
    goo.gl/bbHYu2
    EXCEL TIPS & TRICKS ►
    goo.gl/wAj1jh
    MS WORD ►
    goo.gl/B4TeSA
    HTML5 & CSS3 ►
    goo.gl/2PFgs8
    COMPUTER TECHNICAL videos ►
    goo.gl/paZmpn
    AUTOMATIC INVOICE IN EXCEL ►
    goo.gl/dFhg54
    PHOTOSHOP ►
    • How To Make Passport S...
    Subscribe Deepak EduWorld ► / deepakeduworld
    Instagram ► / deepakeduworld
    Facebook page ► / deepakeduworld
    LinkedIn ► / deepakedu. .
    Facebook Group ► / cse92
    We Always Provide Useful & Helpful Content On The Deepak Eduworld UA-cam Channel, Here MS Excel Tips And Tricks, And Tips And Tricks For MS Word, And Internet Tips And Tricks, Along With The Computer Related Useful Information In Simple Hindi Language. I You Can Visit Our Channel Playlist's. It Is Our Effort To Get This Information Useful For All Types Of Excel Users, MS Word Users, Computer Users And Internet Users.
    Tags : How To Use VLOOKUP With MATCH Function In Excel,excel,vlookup,excel match function,match,match & vlookup,match function with vlookup in excel,match vlookup,vlookup with match function,vlookup match index,vlookup formula,function,formula,hindi,match function,vlookup with match in excel,match formula in excel,vlookup formula in excel in hindi,deepak eduworld,deepak nehra,excel tips,computer tips,excel formulas and functions

КОМЕНТАРІ • 301

  • @DeepakEduWorld
    @DeepakEduWorld  4 роки тому +7

    Vlookup Full Tutorial
    ua-cam.com/video/V4YgQTFLmyc/v-deo.html

  • @RAEES_Kaushar
    @RAEES_Kaushar 11 місяців тому +1

    Sir aap ne to 1 bar me hi samjha dete hai....
    Thank you sir ❤

  • @maazshaikh7102
    @maazshaikh7102 3 місяці тому +1

    Thank you sir. This is so helpful.
    From pakistan 🇵🇰

  • @skasrafulhoque6528
    @skasrafulhoque6528 Рік тому +2

    I saw the many videos but can't understood but now clear all doubts

  • @anilkumarsingh4560
    @anilkumarsingh4560 6 років тому +2

    Thank You Sir jo apne Vlookup + match function ke video publish ke Super Hit video

  • @vikasverma2972
    @vikasverma2972 6 років тому +1

    Helpful vedio thanks i hope ye trick mere bhut kaam ayege

  • @mahindraneog6493
    @mahindraneog6493 4 роки тому +1

    After watching many videos & articles, finally did understand the idea. THANKS.

  • @dakshkumar873
    @dakshkumar873 2 роки тому

    Thank you Sir.
    Sir, Tommorow I will go for Interview.

  • @Abhii425
    @Abhii425 Рік тому +1

    Bhot ache se smjaya bro

  • @nirjuaghera6168
    @nirjuaghera6168 10 місяців тому

    Boss tum exel k king ho 💥

  • @JitenderSingh-hg8wl
    @JitenderSingh-hg8wl 2 роки тому +1

    Great Informative video with great method of teaching. Thanks Sir.

  • @DeepakEduWorld
    @DeepakEduWorld  5 років тому +2

    🇯 🇦 🇮 🇭 🇮 🇳 🇩 🇮🇳 🇮🇳
    *Show Me ♥ By Like Share & Comment*
    🇸 🇺 🇧 🇸 🇨 🇷 🇮 🇧 🇪
    *𝐊𝐚𝐫𝐧𝐚 𝐧𝐚 𝐛𝐡𝐮𝐥𝐞 𝐝𝐨𝐬𝐭𝐨𝐧 (◕‿◕)*

  • @BABYBINGOTV
    @BABYBINGOTV 2 роки тому

    Very well explained. Now, I understand about vlookup+match. Thank you.

  • @onlymahakal4345
    @onlymahakal4345 Рік тому +1

    Very good Dipak sir, I understood very will.

  • @vasimd9278
    @vasimd9278 2 роки тому

    Aap sir ko khuda lambi umar De
    Khush rahe aap sir💕

  • @vaibhavshukla94
    @vaibhavshukla94 6 років тому +1

    Very Good Video Deepak ji..बहुत अच्छा काम कर रहे है आप.

  • @muhammadadnan3900
    @muhammadadnan3900 2 роки тому

    Shukriyah Deepak Bhai 🤞

  • @satydevnegi5454
    @satydevnegi5454 4 роки тому +2

    Very useful material inside the video, thank you Deepak, keep it up

  • @noorqamar7580
    @noorqamar7580 6 років тому +5

    very useful sir g, I have never seen such excellent way of teaching as yours.thanks for loading these videos

  • @SachinSomkuwar
    @SachinSomkuwar Рік тому +1

    Very helpful for survey work

  • @theinsuranceadvisorlic5312
    @theinsuranceadvisorlic5312 Рік тому +1

    Well explained support from Bombay

  • @javedahmed8343
    @javedahmed8343 2 роки тому +1

    Good explanation.

  • @khalidalisubhanallah2947
    @khalidalisubhanallah2947 6 років тому +2

    Bundle of Thanks Sir G Nice Video

  • @thakuryogesh9744
    @thakuryogesh9744 3 роки тому +1

    SIRJEE AAP TOH EXCEL KE BHAGWAN HO. JAISE SACHIN CRICKET KA BHAGWAN HAI

  • @souravdas4958
    @souravdas4958 4 роки тому

    Sir you're just great!!!!!!!
    Keep teaching us

  • @prashant1513
    @prashant1513 4 роки тому

    Superb Dipakaji.

  • @abletuber4324
    @abletuber4324 5 років тому +2

    Very nice formula

  • @MONUYADAV-ue8fm
    @MONUYADAV-ue8fm Рік тому +1

    Thans Bhai Ji.

  • @mr.momlover.308
    @mr.momlover.308 4 роки тому +1

    Maja aa gaya bhai

  • @asadullahghalib4347
    @asadullahghalib4347 2 роки тому +1

    your videos very helpful.

  • @RahulKumar-knp
    @RahulKumar-knp 5 років тому +1

    Very nice video....... good job....👌

  • @amdadulhoque1083
    @amdadulhoque1083 5 років тому +1

    Very Useful Formula
    Thanks

  • @kajaltuteja6489
    @kajaltuteja6489 6 років тому +1

    nice videos
    teaching style is very nice

  • @Kishore_ki_kalam
    @Kishore_ki_kalam Рік тому +1

    Sir I loved it.

  • @deeparanjit5747
    @deeparanjit5747 2 роки тому

    Thank you sir very helpful and clearly understand 😊

  • @anupammuneshwar1057
    @anupammuneshwar1057 6 років тому +2

    Very useful formula
    Thank you very much...Sir
    What a great job...

    • @shrikantkirwale9339
      @shrikantkirwale9339 4 роки тому

      6.30 sec tak point pr nahi aye sir app....video 4 min ka bhi ho sakta tha

  • @parthopratimdas175
    @parthopratimdas175 2 роки тому +1

    Very useful sir

  • @computerknowledge9150
    @computerknowledge9150 4 роки тому

    Sir me apki roz ek video dekhta hu

  • @surbhijain4210
    @surbhijain4210 2 роки тому +1

    Very very useful

  • @samankhan1505
    @samankhan1505 4 роки тому +2

    Really nice 😊👍

  • @parminderbaggi4596
    @parminderbaggi4596 5 років тому +1

    Useful video , very nice

  • @dharam9787
    @dharam9787 6 років тому +1

    Deepak Bhai Fantastic

  • @RATHNAMANOJ
    @RATHNAMANOJ 4 роки тому

    Deepak bhai... you are doing great job! kithna aasaan bana raha hai excel ko... "Main hu Deepak... aap ka dost" aawaaj sunthe hi confusion gaayab ho ja raha hai...! (main hu ranjith... telangana se...main ek school teacher hu... mujhe tho bahuth useful hai aap ke videos... ! thank you very much!!

  • @ritikasingh6948
    @ritikasingh6948 2 роки тому

    Bhot bhot bhot bhot dhnybad

  • @virendrayadav-dj7gg
    @virendrayadav-dj7gg 3 роки тому +1

    RIGHT BHAI JI

  • @AnilKumar-go7hj
    @AnilKumar-go7hj 5 років тому +1

    Very good sir ji

  • @rajsahu1029
    @rajsahu1029 5 років тому +1

    Very good tool

  • @AkashGupta-ik7rq
    @AkashGupta-ik7rq 6 років тому

    Very helpful Sir.

  • @allforedandtech
    @allforedandtech 3 роки тому

    Well Explained..

  • @lokendrachand7859
    @lokendrachand7859 6 років тому

    Very nice Deepak bhai

  • @MdIlyasShaikh
    @MdIlyasShaikh 6 років тому +2

    Excellent.
    Thanks a lot for uploading.

  • @abbsoftcomputers7806
    @abbsoftcomputers7806 5 років тому +1

    very nice video, thanks

  • @vikas18sharma
    @vikas18sharma 5 років тому +1

    Great formula...

  • @iqbalmohammadi6735
    @iqbalmohammadi6735 6 років тому

    Superb sir...

  • @vivosingh4594
    @vivosingh4594 2 роки тому +1

    Thax sir

  • @NoviceSibiandAnex
    @NoviceSibiandAnex 5 років тому +1

    superb bro! you are a superstar!

  • @pranjalsharma429
    @pranjalsharma429 3 роки тому +1

    thanks brother

  • @skyjetxpress9759
    @skyjetxpress9759 4 місяці тому +1

    NICE VIDEO

  • @nomadic_hin27ani
    @nomadic_hin27ani 4 роки тому

    Excellent Deepak. Your videos are very useful. You have vast knowledge of Excel. Good carry on.

  • @xlpointacademy5127
    @xlpointacademy5127 6 років тому

    Super Deepak

  • @shankyjaswani
    @shankyjaswani 4 роки тому

    Thank you so much Brother. It helped me a lot today.

  • @indian35556
    @indian35556 6 років тому

    Great. Very halpful. Thanks

  • @sweetyrani1256
    @sweetyrani1256 6 років тому +1

    bhot achi video

  • @avikroy6444
    @avikroy6444 6 років тому

    thanks for the video deepak ...need more

  • @ADangergaming
    @ADangergaming 3 роки тому

    Thank you very much

  • @Sattie2106
    @Sattie2106 5 років тому +1

    Good job mate...

  • @sherazrathoor8552
    @sherazrathoor8552 6 років тому +1

    nice video Thanku sir....

  • @AjitKumar-pt9jb
    @AjitKumar-pt9jb 4 роки тому

    Useful video

  • @Ankushkumar-vn2qd
    @Ankushkumar-vn2qd 3 роки тому

    Ultimate teach

  • @anilkumarsingh4560
    @anilkumarsingh4560 6 років тому +1

    Sir aise he MIS reports ke videos publish kijiyega Bhut help milte hai

  • @mcnmejia
    @mcnmejia 5 років тому

    Nice video,
    And needful

  • @Runrunjish
    @Runrunjish Рік тому

    Excellent

  • @jehisfiofiojehis2219
    @jehisfiofiojehis2219 5 років тому

    Very nice thanks

  • @bcacsschattarai1544
    @bcacsschattarai1544 2 роки тому

    Great👍👍👍👍👍

  • @nirajkumarsahu4691
    @nirajkumarsahu4691 6 років тому

    Very nice video

  • @kanhucharanadas3948
    @kanhucharanadas3948 6 років тому +1

    Deepak sir very execellent

  • @geoagainagain
    @geoagainagain 4 роки тому

    I like your "heyna" word 😘

  • @pkjksk
    @pkjksk 4 роки тому

    Thanks you Sir

  • @IftakharAhamed
    @IftakharAhamed 4 роки тому

    Bro u r really great. I like u & never missed u'r tutorial.

  • @MuneerAhmed-ke7tt
    @MuneerAhmed-ke7tt 6 років тому +1

    Excellence Thanks a lot

  • @pranjalnath2757
    @pranjalnath2757 6 років тому +1

    thank you man, well explained

  • @dipakkshirsagar9794
    @dipakkshirsagar9794 2 роки тому +1

    Thanks

  • @nmy100
    @nmy100 4 роки тому

    superb

  • @tellyone
    @tellyone 3 роки тому +1

    Sir aap mughe itna bata sakte hai kya ki ye jo apne abhi sikhaya yr basic hai.? Ya fir iske aage or bhi kuch hai..?

  • @nageshkumar2192
    @nageshkumar2192 6 років тому +1

    Thanks sir ji

  • @anjalirajhans1163
    @anjalirajhans1163 4 роки тому

    Helpful😃

  • @krishnaaggarwalvlogs2348
    @krishnaaggarwalvlogs2348 5 років тому

    Thanks a lot sir ..

  • @ajaymaster01
    @ajaymaster01 6 років тому

    Bahot accha dost, mai samjhta tha ki Excel ka father mai hu, lekin aap to mujhe v aage nikle, maine ye sb socha ni tha lekin output kya chahiye wo puccho to function khud se laga lunga.

  • @ibm98852
    @ibm98852 5 років тому +1

    Awesome

  • @computerknowledge9150
    @computerknowledge9150 4 роки тому

    Super sir

  • @puneetvij8433
    @puneetvij8433 6 років тому +3

    Deepak Sir,
    Video बहुत काम का है, job लगवाने में मदद करेगा |
    मेरी एक request थी कि Graphs पर एक पूरा tutorial बनाए जिसमें हर option के बारे में जानकारी हो, क्योकिं graphs तो बन जाते है मगर उनकी formatting करने में बड़ी दिक्कत होती (Axes, legends, color etc.). ; )

  • @parshu_sonkar_
    @parshu_sonkar_ 6 років тому

    Nice video sir

  • @shamsularfeen7477
    @shamsularfeen7477 2 роки тому +1

    Hello Deepak,
    GST me Tally with ITC matching ke liye ek Vdo bnaye plz. Q ki GST me hme ek sath kayi Sare Values check krne hote hain.
    Isliye meri Request hai ispe jald se Jld bnaye.

  • @md.shafiqurrahman5721
    @md.shafiqurrahman5721 Рік тому +1

    Nice

  • @sagarkanade7110
    @sagarkanade7110 4 роки тому +1

    Very nice sir...
    Sir kya aap bata sakte ho ki jaise vlookup multiple line ke liye use hota hai... Vaise vlookup + match multiple line pe use ho sakta hai?

  • @neharathore1157
    @neharathore1157 4 місяці тому +1

    Sir vlookup ke formule me column number ki jhangha cell nahi de sakte kya

  • @shail177
    @shail177 Рік тому

    Please make a video compare with the different months date wise also

  • @archanaaa2514
    @archanaaa2514 4 роки тому +2

    Hello sir,, same calculations we can do by index match also right?

  • @ajitsinghbisht4233
    @ajitsinghbisht4233 6 років тому +1

    awesome

  • @taruntarun4319
    @taruntarun4319 6 років тому +2

    MR. TARUN NICE VIDEO SIR