VLOOKUP in Excel | VLOOKUP Formula in Excel |

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

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

  • @GrowWithSkills
    @GrowWithSkills  4 месяца назад +14

    Hey Viewers, there is an update. In this video you need to freeze the lookup value and table array also need to use column function in the place of column index number. I have explained all the thing in my another videos.

    • @surajpunia6400
      @surajpunia6400 2 месяца назад

      @@GrowWithSkills thankyou my favourite ms Excel give me more formula function

  • @Mohammed-yc6nn
    @Mohammed-yc6nn 7 месяцев назад +32

    I don’t even speak Hindi but I understand. Your use of example is very easy to follow. Well done!

  • @Behappyalways309
    @Behappyalways309 Год назад +45

    Learnt and practiced. Thank you.

  • @VinitVPK
    @VinitVPK 6 месяцев назад +1

    मुझे आपका समझाया हुआ ही समझ आरा हैं mem ❤ धन्यवाद

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

    madam mujhe aj tak vlookup formula use main lena NAHI AAYA LAKIN AAPKE VIDEO SE ITNA EASILY SIKH GAYA OR KAM EASILY HO GAYA THANKU

  • @hindu9299
    @hindu9299 8 месяцев назад +4

    Apki awaz bhot sweet hai thank you mam

  • @iloveyourstatus3929
    @iloveyourstatus3929 3 дня назад

    Thnks mam helpful I'm civil engineer in government it's helps to prepare estimate

  • @juberahmadkhan8315
    @juberahmadkhan8315 Месяц назад

    Very nice video so much

  • @pradnyakamble3958
    @pradnyakamble3958 6 месяцев назад

    Thanks for the easy explanation 😊

  • @King.playzzz07
    @King.playzzz07 9 дней назад +1

    Vlookup match kaa use karna tha mam

  • @kvamsisrinivas
    @kvamsisrinivas 9 дней назад

    Working గుడ్ job

  • @AlMuslimaH1090
    @AlMuslimaH1090 25 дней назад

    Good. Work sister

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

    Super explanation n voice.V,H Lookup has multiple benefits. Teach other uses ❤

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

    I love your way to explain❤

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

    you made it so simple, thanks

  • @strange4986
    @strange4986 11 дней назад +1

    Last by by got me 😂❤

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

    One of the easiest explanations out there. Thank you

  • @Newversionking
    @Newversionking Месяц назад

    You are right 👍

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

    Thank you so much

  • @vijaythakor-bx3zd
    @vijaythakor-bx3zd Месяц назад

    Thank you

  • @Kumarsanjeev-mk1dw
    @Kumarsanjeev-mk1dw Год назад +1

    Wah so esy ...thank you very much

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

    Apka batane ka tarika sabse achha laga baki other logo ki video ke according 🥰

  • @punitshrivastav2709
    @punitshrivastav2709 5 месяцев назад

    Nice explain 😀

  • @rbgulzar4893
    @rbgulzar4893 5 месяцев назад

    I love you mam, you teaching methood is so awesome!

  • @smrtrdr1222
    @smrtrdr1222 18 дней назад

    Thankss

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

    Thanks alot

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

    very well explained. Salute mam :)

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

    What a voice, lovely

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

    Super 👌 ❤ Tq

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

    Thnx uh so much❤

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

    Very nice miss

  • @Ekmev_Sanatani
    @Ekmev_Sanatani 3 месяца назад +6

    Quantity ke liye VLOOKUP kaun lagata hai Di???
    Apko price ke liye lagana tha aur col index 3 lena tha

  • @tejaswinipatil5487
    @tejaswinipatil5487 Месяц назад

    Easy Thankss❤

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

    Didi aapne toh Jadu kar diya... Kisi ka vlookup mujhe nhi a rha tha aaka ka toh jaise koi mazik ki tarha ho gya vloookup

  • @shravyashetty1755
    @shravyashetty1755 5 месяцев назад

    Awesome ❤

  • @Tkmc-y9v
    @Tkmc-y9v 6 месяцев назад

    Bahot achche se smjh aa gya

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

    Lovee u yaar kya baat hai simple way me bata dia ❤

  • @SujalPrajapati-pn4eb
    @SujalPrajapati-pn4eb Год назад +13

    Bye bolne ke tarike se like karne ka dil kiya ...to kar diya..😂😂😂

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

    Thankyou so much 😊

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

    Cell range lock kiye bina formula drag krne par formula me cell range bui change ho jayega to ye formula kaam nahi karega jaisa apne bataya hai is video me

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

      I have Explained all the details on long video. Please check that too.

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

      @@GrowWithSkills to ye kya baat Hui. Ek video me adhuri jankari de Rahi ho AAP.

  • @SA-ui4tf
    @SA-ui4tf 8 месяцев назад

    Thanks 😊

  • @Brain99.9Humans
    @Brain99.9Humans 10 месяцев назад

    Simple tha aur samaj agaya didi

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

    Nice. Thanks

  • @JabirCk-lo3tu
    @JabirCk-lo3tu 9 месяцев назад

    This is great tutorial saved our time. Appreciate your work mam. Some people will take 5-10 minutes to explain this😂 for making video more lengthy

  • @sohaibkhan-om4fh
    @sohaibkhan-om4fh 2 месяца назад

    You can use index formula in cell 2

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

    Kon sa formula kab lagana h..kese pata chalta h..qki bahut sare formule hote h...exact ka pata kese kare?

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

      Koi bhi formula yaad karne ki need nahi hai with practice apne aap clear ho jaega.

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

      @@GrowWithSkills to...ek video banay civil engg. me excel me kya kam hota h..aur usse related formule kon se h...

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

      @@dheerajsingh4462 I am not from civil engineering background so I don't know ki actual konse formulas use hote hai but I will research and try to make video on that.

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

      @@GrowWithSkills jese pivot table,data sorting & analysis, billing and estimation formats etc. Baki basic aur formule ki to h videos..so..try to make a video on it..
      as early as possible.

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

      Ya ham logo ke upper depend karta hai ki hame Kitna knowledge hai yadi excel ka sahi se knowledge ho gaya to appne se formula use Karne lagoge

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

    Amazing ❤

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

    Nice

  • @anilmathangi1591
    @anilmathangi1591 2 дня назад

    Ma'am drag karne par nahi ho Raha kya problem ho sakta hai

    • @GrowWithSkills
      @GrowWithSkills  2 дня назад

      Please check pinned comment apko vlookup + column function use karna hoga. Channel par video hai aap check kijie clear ho jaega

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

    Thanks

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

    Mast

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

    Hello mam price column ka column index number 3 rahega na to drag Karne par kaise aa gaya

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

      Please check this playlist: studio.ruclips.net/user/playlistPL8qTPzPvOrCuM-zQUgej6iffCnshkrBFW/videos

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

      Hello mam ye link kis liye share KIYE ho

  • @Arjunneemi6915
    @Arjunneemi6915 2 месяца назад

    Price mein kese apply kare??? Price nikal rahe h toh N/A aa raha h 2,0 ke liye bhi nhi aa raha

    • @GrowWithSkills
      @GrowWithSkills  2 месяца назад

      Aapko column function use krna hoga column index number ki jagah channel par video hai aap wo dekh skte hai

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

    Apki voice bhut achi hai mam 😁 and formula smjh a gya hai 😍

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

    omfg ! thank u

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

    Tqqqq

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

    Thank you for this video
    More useful to me
    Thanks a lot

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

    Full. Computer couree

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

      Please check long video on my channel.

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

    Yes,got it VLOOKUP 🎉 thanks mam

  • @tusharchawla03
    @tusharchawla03 27 дней назад

    easyyyyy

  • @AmanSharma-tk4nw
    @AmanSharma-tk4nw 3 месяца назад

    Mam mere N/A bata raha hai.... As it is aapke jesa karne ke bawjood?????????

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

      Please check this video: ruclips.net/user/shortsqNZoSL3ww6E?feature=share and ruclips.net/user/shortsNdS1aU73lto?feature=share

  • @sakshimittal1606
    @sakshimittal1606 2 месяца назад

    Won't we say H when asked about column? I'm confused please help

    • @GrowWithSkills
      @GrowWithSkills  2 месяца назад

      Please elaborate your query for better understanding

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

    Thanks

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

    Thank you so much

  • @surajpunia6400
    @surajpunia6400 2 месяца назад

    hlookup formula bahto dear

    • @GrowWithSkills
      @GrowWithSkills  2 месяца назад

      Channel Par Uploaded Hai, Please Check

  • @Imrancreative001
    @Imrancreative001 2 месяца назад

    Fillter use kar sakte hai na itna karni ki kya zarurat

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

      Kar Sakte ho but what if data another sheet or workbook mai manga jae?

    • @Imrancreative001
      @Imrancreative001 2 месяца назад

      Right 👍 👍 I forgot that 😅​@@GrowWithSkills

  • @AmitKumar-xq6yd
    @AmitKumar-xq6yd Месяц назад

    bybyyy🎉

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

    😊😊😊

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

    It's like copy & paste

  • @NehaNeha-fz7mb
    @NehaNeha-fz7mb 4 месяца назад

    😊😊😊😊

  • @rajshripandit4013
    @rajshripandit4013 5 месяцев назад

    👍🏻

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

    Mera n hua yrr

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

    mam which is this office?

  • @Mrqasim-bq4qx
    @Mrqasim-bq4qx 4 месяца назад

    Bhai me Sikh gya 😢

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

    False and true kyu likhte hai?

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

      TRUE for approximate match and False for exact match

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

    Copy paste potlae pothuum

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

    Apne galat kiya hh😮.
    Apko drag karne se pehle usko lock krna chahiye tha

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

    Very good

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

    Nahi aa rha hai mera

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

      Please check this video: ruclips.net/video/UF8qTivePeE/видео.html

  • @DivyaSharma-r3f
    @DivyaSharma-r3f 3 месяца назад

    how can you drag the value without freezing the lookup value? wrong explanation!

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

      Please check pinned comment also check the long video

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

    Love u

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

    Bbye

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

    Thank you, ap jaldi se bol dia 20 minutes ka video me faltu bakwas na karke

  • @armanansari1955
    @armanansari1955 2 месяца назад

    =sun (h3%i4)ENTER

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

    Didi v look up ko dreg nahi kar sakte kuki lookup dreg nahi hota

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

      Drag Kar sakte h with column and Row Function. Mene Us par bhi Video Banai Hai.

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

      Vlookup ko horizontal and vertical dono ek sath drag kar sakte hai eske liye hame column and row ko avsakta anusaar fix ttha unfix Karna hota hai

  • @Aiman-g4d
    @Aiman-g4d Год назад

    ta ta

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

    B by😂

  • @TejuKale-eo6ih
    @TejuKale-eo6ih 10 месяцев назад

    Hiii mam

    • @TejuKale-eo6ih
      @TejuKale-eo6ih 10 месяцев назад

      VLOOKUP/HLOOKUP madhye kiti parameters mhnje approximate match hotat.

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

    Bekar function

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

    Useless

  • @Pixierj
    @Pixierj Месяц назад

    Mere computer me nai hora hai

    • @GrowWithSkills
      @GrowWithSkills  Месяц назад

      Please check this video: ruclips.net/video/vNmczNhX8Bo/видео.html

  • @rehanahmedsiddiqui5535
    @rehanahmedsiddiqui5535 13 дней назад

    Bye bye mam

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

    Thank you

  • @yathinkumar9973
    @yathinkumar9973 5 месяцев назад

    Thank you