How To Use VLOOKUP Formula in Microsoft Excel | VLOOKUP in Excel | Excel VLOOKUP

Поделиться
HTML-код
  • Опубликовано: 5 дек 2024

Комментарии • 390

  • @rajkumarrathore2846
    @rajkumarrathore2846 11 месяцев назад +37

    Incredible, I know how to use vlookup in Excel. Unfortunately, I didn't know why we use and little confusion.
    Now, I complete understand this concept.
    Thank you 😊.

    • @yuvrajsingh121
      @yuvrajsingh121 5 месяцев назад +3

      automation ke liye mostly. let's se yehi example ka data bahut large hota. toh hume kuch bhi search karne ke liye pura scroll down karna hota. so upar hi ek vlook up bana dunga tak jiska bhi data chahiye wo sirf type karu main aur uska value aa jaye

  • @guncharanjan8145
    @guncharanjan8145 11 месяцев назад +32

    Bhot time baad koi itna easily smjha re thanku so much

    • @DOCTORPC-o8x
      @DOCTORPC-o8x 3 месяца назад +1

      @@Offx._saurabh KYA BOLA HAI BHAI

    • @Offx._saurabh
      @Offx._saurabh 3 месяца назад

      @@DOCTORPC-o8x kuch nhi

  • @Sougata-k7r
    @Sougata-k7r 10 месяцев назад +11

    8 bar try karne ka bad me safal hua thanks a lot.

  • @gundayyaswamy7201
    @gundayyaswamy7201 Год назад +6

    aapka ye chhota sa video bahut logo ko job dila chuka hoga awesome

  • @tapsg1188
    @tapsg1188 Месяц назад +2

    The easiest, most clear and very simple tutorial that i have come across!! Thanks a lot 🙏❤

  • @shivamyadav-ff4gj
    @shivamyadav-ff4gj 9 дней назад +1

    thank you so much sir i am very confused in vlookup but i see your video thats really great

  • @falcon___96
    @falcon___96 7 дней назад +2

    Osm trick of teaching 🎉

  • @YASHVEERSINGH-b3t
    @YASHVEERSINGH-b3t Год назад +1

    Love you Sir From Sonipat Haryana 🇮🇳🕉️

  • @SiddharthSingh-j1q
    @SiddharthSingh-j1q День назад +1

    Very good information ❤❤

  • @Raghvendra3434
    @Raghvendra3434 4 дня назад

    Very simple and accurate method of explaining. Bro but ek example vlookup ka 2 different excel sheets ke beech ka bhi share kar do. It will also help us.

  • @Raivick
    @Raivick Год назад

    Baut time se samjh Raha thaa .. lekin apki video se hi samjh aya .. thnks sir ❤❤❤ . Apka channel aur grow hoga .. dua hai meri

  • @Sambhajinagar_ststus_vlog
    @Sambhajinagar_ststus_vlog Месяц назад +3

    Nice is very helpful for easy learning and job placement.

  • @princerajput1503
    @princerajput1503 6 месяцев назад +10

    one of the best video in very simple way to learn vlookup

  • @syednayeemhussain5657
    @syednayeemhussain5657 Месяц назад +1

    Superb sir today i have done lookup by applying F4.

  • @mrturboautomobiledesigneng1716
    @mrturboautomobiledesigneng1716 8 месяцев назад +1

    So simple to understand, thanks bro

  • @muhammadsarfraz9219
    @muhammadsarfraz9219 8 месяцев назад

    Brilliant method for teaching...thank you so much...

  • @infofactory1
    @infofactory1 Год назад +16

    Very good explanation but using filters are better than vlookup.
    Apply filter, copy the data and paste whereever you want. No need for tipical formulas.😜

    • @avikchatterjee4838
      @avikchatterjee4838 Год назад +1

      😂😂😂

    • @rubysharma3516
      @rubysharma3516 10 месяцев назад

      Completly Right, itna natak Krna hi kyu... formula wala

    • @rubysharma3516
      @rubysharma3516 10 месяцев назад

      Jab table array ko Select kr rhe h, to us Row ko copy krlo-. Kaam ho jyega

    • @vivekbhatt4400
      @vivekbhatt4400 10 месяцев назад

      Nahi Bhai filter ke alawa bahut use hai iska

  • @ankush_comedy368
    @ankush_comedy368 2 дня назад +1

    Super video ❤❤❤

  • @sashankamitra2494
    @sashankamitra2494 4 года назад +1

    Thank you sir help🙏🙏 korar jonno

    • @StudySpan
      @StudySpan  4 года назад

      You are mostly welcome... Stay tuned

  • @happynature5356
    @happynature5356 Год назад +4

    Very good teaching skills with a superb voice.

  • @kaushalmahetaliya8194
    @kaushalmahetaliya8194 4 месяца назад +3

    Very Nice Video...Exact formula...Thank you so much sir....👍👍👍👌👌

  • @adilanjumkarachiwala9066
    @adilanjumkarachiwala9066 2 месяца назад +1

    Bhot axha video sir g very simple❤

  • @rmsantosh9576
    @rmsantosh9576 4 месяца назад +1

    Very Nice Explanation 😊
    Thank You So Much Sir ❤😊

  • @gouravpathak5620
    @gouravpathak5620 7 месяцев назад +6

    Thank you......team
    I learnt the Vlook up thank you for the tutorial

  • @vaishalirathore4366
    @vaishalirathore4366 Год назад +1

    Jaise basic salary humne khud di h ese net salary bhi khud Deni hogi ya formula use hoga

  • @austindean9274
    @austindean9274 Год назад +1

    Your teaching method is too good

  • @ashutoshboss711
    @ashutoshboss711 11 месяцев назад

    Aapka samjhe ka tarika bahaut sundar hai.

  • @vikkypandevlogs
    @vikkypandevlogs Год назад

    Thanks Sir clearly explained formula 🙏🙏

  • @success1513
    @success1513 4 месяца назад +2

    1:39 we we should press F4 ?

  • @MaxSpecail
    @MaxSpecail 10 месяцев назад

    Thankyou sir Mast Tarika Easy Step__😇

  • @fahadchittagong8454
    @fahadchittagong8454 Год назад +2

    Very good 👍 video for learning V-Lookup

  • @surendranarayan2729
    @surendranarayan2729 9 месяцев назад

    Thanks, video saaf hai, usefull hai ,

  • @SIMARAN_VLOGS
    @SIMARAN_VLOGS 2 года назад

    Thq soo much sir ... Apki vide bhut achi ha

  • @KaaleKiKahaanee
    @KaaleKiKahaanee 3 месяца назад +1

    bahut acha sabse ache your video in RUclips

  • @arkapravasarkar951
    @arkapravasarkar951 2 месяца назад +3

    Nice vedio sir ❤
    But when it will be TRUE instead of FALSE ??
    Pls reply 😊😊

  • @durgeshrathod236
    @durgeshrathod236 Год назад +9

    sweet and simple and to the point video must see for vlookup

  • @Shahisworld
    @Shahisworld Год назад +1

    Thanks yr maza aagya 🙌

  • @kalpanayadav9935
    @kalpanayadav9935 Месяц назад +1

    Thank you very much Sir !

  • @sagarket
    @sagarket Год назад

    Thanks lot sit very nicely explained KEEP IT UP SIR............!

  • @dvnkp0404
    @dvnkp0404 Год назад +1

    THANKS NICELY EXPLAIN.

  • @Aradhya_Maurya
    @Aradhya_Maurya 2 месяца назад +1

    Thank you so much😊❤

  • @SunilNagaraj-n4r
    @SunilNagaraj-n4r 5 месяцев назад +1

    very nice, neatly explained ,thank you

  • @s.d9667
    @s.d9667 2 года назад +3

    Sir ,
    Your each video is supportable for me
    Lots of thanks sir please stay continue posting new. Videos

    • @StudySpan
      @StudySpan  2 года назад

      You are mostly welcome. Stay tuned for latest videos

    • @arpan8584
      @arpan8584 Год назад

      Formula lagae Bina directly ni likh sakte sir

  • @Kidschanel-n2w
    @Kidschanel-n2w 7 месяцев назад +1

    Thank you sir very helpful video for beginner Excel Learners

  • @radhikasalesradia498
    @radhikasalesradia498 7 месяцев назад +1

    THNX, IT WAS VERY USEFUL FOR ME

  • @Moizfarhan
    @Moizfarhan 4 месяца назад +2

    Thanks🎉Very helpful for me

  • @yogeshnitnaware2507
    @yogeshnitnaware2507 Год назад

    Thank you thank you thank you so much.😊

  • @gaurishsalgaonkar6926
    @gaurishsalgaonkar6926 5 месяцев назад +1

    Thankyou Sir.. very useful for appraisal
    letters

  • @MeghaMusyuni
    @MeghaMusyuni Год назад

    Thankyou so much sir ... This video is really help me

  • @WHITE333DA
    @WHITE333DA 8 месяцев назад +1

    Agr aik se ziada summon roy ho yani aik sheet me 3 summun roy ho to kesy hoga sir

    • @As19-r7u
      @As19-r7u 5 месяцев назад

      Sr.no ke hisab se dhek lenge yaar

  • @puneetkumar5328
    @puneetkumar5328 Год назад +5

    Informative video but there is no need to freeze using F4

  • @snlove3997
    @snlove3997 Год назад

    Thank sir aap bahht achha samjhate ho

  • @sabirnawazbhutto
    @sabirnawazbhutto Год назад

    Nice explained sir, tomorrow I have interview and I was worry but u made it easy.😊

  • @Rishi-xl3ro
    @Rishi-xl3ro 4 месяца назад +1

    It's time consuming in learning..thanks

  • @InspireTheWorld96
    @InspireTheWorld96 9 месяцев назад

    Very helpful... Thanx 👍

  • @nikitakorade1291
    @nikitakorade1291 23 дня назад +1

    Thnkuuuu so much ❤

  • @ShivamYadav-yz7zd
    @ShivamYadav-yz7zd Год назад +1

    Very usefull knowledge sir thank u so much ❤❤❤❤❤

  • @sunnyhotwheelss9883
    @sunnyhotwheelss9883 4 года назад +1

    1st comment 😋
    Superb 👌
    #SunnyHotWheelsS 😎

    • @StudySpan
      @StudySpan  4 года назад +1

      Thank you so much...stay tuned

  • @hitback4181
    @hitback4181 Год назад

    Nice & useful video! Thank you!🙏

  • @bugswithlove8502
    @bugswithlove8502 9 месяцев назад +1

    Perfect sir...nice video.

  • @chickooshukla2364
    @chickooshukla2364 Год назад

    Thank you do much I also know about vlookup now

  • @himanshurajak1488
    @himanshurajak1488 Год назад

    Fantastic way to explain 😮😮😮😮😮😮Wow man all the best bro

  • @bahamonimurmu8620
    @bahamonimurmu8620 7 месяцев назад +1

    Good teaching 👍👍👍

  • @Tanmaykiduniya-o1h
    @Tanmaykiduniya-o1h Год назад

    Thanks for detail information.

  • @abhayrajput7316
    @abhayrajput7316 2 года назад +1

    sir agar ek hi nam ke do person hain to usme kaise krte hain

  • @sabafarin5011
    @sabafarin5011 2 года назад +13

    Thank you sir for your good explanation

  • @vaishalirathore4366
    @vaishalirathore4366 Год назад +1

    Sir plz pura video RUclips pr share kijiye taki ache sai smhj aaye ese choti video smhj ni aati agr kro to pura video bnao Jo smhj aaye

  • @soumyadip7480
    @soumyadip7480 Год назад +1

    Thank You Sir😊

  • @suryaabhattt7554
    @suryaabhattt7554 Год назад +11

    But why vlookup is used??

  • @Vkkiduniya143
    @Vkkiduniya143 Год назад

    Thanks for guidance

  • @mahithkumarmamillapalli8309
    @mahithkumarmamillapalli8309 Год назад

    Thank you for the explanation ...

  • @aryantube7641
    @aryantube7641 4 месяца назад +1

    Thank you sir 🙏🏻

  • @ruhaan1206
    @ruhaan1206 2 месяца назад +1

    *bhai alag sheet se data uthana ho to kaise karenge ?)

  • @mdtanveeralam7659
    @mdtanveeralam7659 Год назад

    Thank you so match for this vedio ❤

  • @NamasteSharmaji
    @NamasteSharmaji Год назад

    Designation k according agar name search krege toh kya formula rahega??

  • @praneethaguthula4869
    @praneethaguthula4869 10 месяцев назад

    Thanks for the explanation

  • @jayashreebehera982
    @jayashreebehera982 2 года назад +1

    Sir,, False match me( 0 ) press karte h ... True match me kya press karte h...??

  • @simranverma8982
    @simranverma8982 Год назад

    This vdio is very useful sir

  • @Rohitnetwork-r
    @Rohitnetwork-r 2 года назад

    my doubts Clearly this video fantastic

  • @banerjeearunava6993
    @banerjeearunava6993 10 месяцев назад

    Awesome vedio 👍👍

  • @ToThoseWhoVanished
    @ToThoseWhoVanished Год назад +3

    Sir good explanation, also tell the reasons logic behind.

  • @ArjunMahour-z7s
    @ArjunMahour-z7s 7 месяцев назад

    Kya hum vlookup formula ko Bina lock kiye use nhi kr skte kyaa?

  • @SagarPradhan-ne1lx
    @SagarPradhan-ne1lx Год назад

    Thanks a lot Sir 🙏

  • @TauhidKhan-ug1ud
    @TauhidKhan-ug1ud Год назад +3

    what is the benefit of freezing the selected cells by F4 ?

    • @asifayoub8535
      @asifayoub8535 Год назад +3

      You can change serial number and data will change accordingly

    • @desiredspots-629
      @desiredspots-629 Год назад

      ruclips.net/video/n880FJBOmUY/видео.html

  • @guncharanjan8145
    @guncharanjan8145 11 месяцев назад

    It's a humble request pivot table pe video bnaiye

  • @mrroy3569
    @mrroy3569 4 года назад +2

    Important topic sir🔥🔥🔥

    • @StudySpan
      @StudySpan  4 года назад +1

      Yes... Stay tuned for more informative videos...

  • @rajendraingole1131
    @rajendraingole1131 Год назад

    Very nice short video

  • @gracefullybroken7410
    @gracefullybroken7410 Год назад

    It's helpful
    Thank you Sir

  • @andreas_Salve
    @andreas_Salve 9 месяцев назад

    Nice

  • @StepByStepExcelTutorials
    @StepByStepExcelTutorials 7 месяцев назад +1

    Really good video!

  • @shreyanshimaurya7281
    @shreyanshimaurya7281 Год назад +15

    Very nice explanation 👏
    Thank you Sir ❤

  • @garimapathak2373
    @garimapathak2373 Год назад

    Thanks a lot🙏

  • @kaushiki.sharma
    @kaushiki.sharma 23 дня назад +1

    thanks buddy!

  • @chartered0784-mp4oh
    @chartered0784-mp4oh Год назад

    sir ji have you uploaded any video related to Hlookup

  • @chhharsha
    @chhharsha 10 месяцев назад

    could you please tell how vlookup work in case of example if name of employee repeats or if there are more than 1 same name of person?

  • @anirudhagupta7382
    @anirudhagupta7382 5 месяцев назад +1

    Thank you sir!

  • @vibsvibs2510
    @vibsvibs2510 Год назад

    Par why do all this when can simply paste the data.. U shud have shown how to do this on different worksheet

  • @keifayathussain6433
    @keifayathussain6433 2 года назад +1

    Informative topics keep going sir

    • @StudySpan
      @StudySpan  2 года назад +1

      Thank you so much. Stay tuned for latest videos

  • @priyadeviv9895
    @priyadeviv9895 Год назад

    Thank you so much 🎉

  • @success1513
    @success1513 4 месяца назад +1

    1:39 what is the need to press F4 ?