How to Use VLOOKUP with MATCH Function? Advance VLOOKUP in EXCEL

Поделиться
HTML-код
  • Опубликовано: 8 сен 2024
  • Download File Here: www.mediafire....
    Today We will learn how to use VLOOKUP Function with MATCH Function. It is going to be very powerful integration.
    Both Vlookup and Match are the Lookup Functions of Excel. Preciously we used and integrated Index with Match.
    #Vlookup #Match #easyexplain #akashgurjar
    Using Match function with Vlookup will help you to resolver your problem of counting column number in vlookup formula.
    if you apply Match function in Column number argument then you will never have to count Column Numbers in Vlookup.

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

  • @poojapanchal9597
    @poojapanchal9597 26 дней назад

    Bravo the way you explain this formula it makes easier to understand

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

    Very informative and simple explanation thanks❤ I am from Pakistan

  • @Raaz3896
    @Raaz3896 3 месяца назад

    Thanks aaj kuch new sikha mene

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

    Very nice explanation sir

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

    Nice

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

    Love from Bangladesh. Good job.

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

      You're Welcome. Keep Sharing 🔃♥️👍🏻

  • @JamesMathew2023
    @JamesMathew2023 3 года назад

    Cool

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

    Osm

  • @anjalikamble1888
    @anjalikamble1888 3 года назад +1

    Best RUclips channel for Excel ...
    Very well explained in just a few minutes 😸

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

    Generally i don't comment on any video, but in here i am thanking you for making this video. You have made it very easy for people to understand and learn at a glance. Good job. Keep it up.

  • @ankitpatel157
    @ankitpatel157 3 года назад

    Thankyou sir for make samart work

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

      You're welcome. Keep Sharing 🔃♥️👍🏻

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

    Thank you

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

    Thanks for this video and nice explanation Sir.

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

      You're Welcome Sir. Keep Sharing 👍🏻

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

    AWESOME, WONDERFUL

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

    Really your way of explanation is very good ❤️❤️

  • @897treder2
    @897treder2 4 года назад

    Bahut achhe sir ji

  • @TechnoFaiz
    @TechnoFaiz 3 года назад

    Ye video jaadoo hai bhai... ultimate 👍

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

    Nice explanation sir❤️❤️

  • @ahmedshakebzubairi25
    @ahmedshakebzubairi25 3 года назад

    Excellent. Counting the number in vlookup was a headache.

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

    Thanks for such good and easy explanation

  • @jweelnath
    @jweelnath 3 года назад

    Thank you so much. We need more more videos

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

    Nice thanks!!

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

    Superb sir are u explain and showing superb I inspired you excellent

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

      Very happy. I am inspiring some one. 😊🙏👍🏻👏

  • @aswinikumarmohanty8092
    @aswinikumarmohanty8092 3 года назад

    Very good explain

  • @adarshkumar642
    @adarshkumar642 3 года назад

    Nice bhai

  • @allforedandtech
    @allforedandtech 3 года назад

    Wow..

  • @mrinalbera5661
    @mrinalbera5661 3 года назад

    Nice video sir

    • @EasyExplain
      @EasyExplain  3 года назад

      You're Welcome. Keep Sharing 🔃♥️👍🏻

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

    Excellent video. Sir can we do that with vlook up and indirect ? If yes then kindly upload that video too

  • @priyankanikalje1666
    @priyankanikalje1666 3 года назад

    Superb Sir🙏thx

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

    Overall it was good Instead of changing above codes or names we can create dropdownlist sir............

  • @Vishwkarmadk
    @Vishwkarmadk 7 месяцев назад

    Isme sir vlookup value ko column ko bhe freeze hona chahiye nhi to next column me is formula ko apply karenge to value bhi next column ki lega

  • @AftabAhmed-uw4ki
    @AftabAhmed-uw4ki Год назад

    Sir plz kutools ki video full tutorial bnao plz

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

    Superb...thank you so much👍

    • @cesarbraylon6708
      @cesarbraylon6708 3 года назад

      a trick : watch movies at flixzone. Been using them for watching all kinds of movies recently.

    • @kyngahmed3667
      @kyngahmed3667 3 года назад

      @Cesar Braylon Yup, I have been using flixzone for since november myself :D

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

    department ko apne row sa select kun kra hai woi tu column sa bh select krsktay hn kia?

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

    How to paste value when filter is applied?

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

    dear sir
    may be understand but multy per match how is posiabale

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

    Bahut chhota dikh rha tha, thora bara likha kijiye sir

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

    Nice bro kai video dekhi par samjh nahi aya tumhara video detail me he

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

    When you freez how many times you press F4

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

    Freeze Kane ka logic kya hai explain us with all columns

  • @smrutisahoo3677
    @smrutisahoo3677 4 месяца назад

    How to apply in different sheet

  • @crazymode3359
    @crazymode3359 3 года назад

    Thanks man ❤️

    • @EasyExplain
      @EasyExplain  3 года назад

      You're Welcome. Keep Sharing 🔃♥️👍🏻

    • @crazymode3359
      @crazymode3359 3 года назад

      @@EasyExplain sure

  • @TIE-TakeItEasy
    @TIE-TakeItEasy 3 года назад

    I am a new learner. I do not face any difficulty while setting formula... but if I try to drag formula right side and downwards, I get confused which arguments has to be fixed. is there any particular rule? how can I know it? After all, it was a wonderful presentation.

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

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

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

    Incase pura tabe uthana ho to kese kre

  • @dharmendragurjar2344
    @dharmendragurjar2344 3 года назад

    Hi bro please one vedio 7 QA tools

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

    Bhai android m excel sikhne ka tarika bta dena..... Plz

  • @santoshkumar-rd2ws
    @santoshkumar-rd2ws 3 года назад

    Bro jack ka department or country nikalna ho to kaise nikalenge

  • @mayurrajput3618
    @mayurrajput3618 3 года назад

    Hello sir
    I have question
    Name. Weight. Height.
    Hulk. 42. 200cm
    Thor. 58. 180 cm
    Iron man. 56. 210cm
    Hulk 60. 250cm
    Sir
    How to find 2nd time Hulk data using vlookup
    I am confused pls help

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

    This formula is not working in 2 diffrrent excel workbook

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

    30+ column ki table par kaam karna padta tha, tab yah formula nahi mila

  • @sandeepsomanath7643
    @sandeepsomanath7643 3 года назад

    Why u r using foreign name use indian name

    • @EasyExplain
      @EasyExplain  3 года назад

      Dummy Data has been taken randomly.

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

    department ko apne row sa select kun kra hai woi tu column sa bh select krsktay hn kia?