i Applied VLOOKUP on 7000 Entries in Just 1 minute in Excel (New 2 Examples) Vlookup on Large Data

Поделиться
HTML-код
  • Опубликовано: 29 сен 2024
  • Download Practice File 👉 techguruplus.c...
    Join Excel Course 👉 TechGuruPlus.c...
    Cheque Printing Software 👉 chequeprint.in
    How to apply VLOOKUP on Large / Big Data in Excel (Hindi)
    .
    🔴 Facebook / techguruplus
    🔴 Telegram t.me/TechGuruPlus
    🔴 Instagram / nazim_excel
    ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
    (1) Excel Videos • Top 20: Advanced Excel...
    (2) Tally Videos • Email through Tally wi...
    (3) Sponsored Videos • Edraw Max: Perfect Sof...
    ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
    ➟ Contact: nazim.khan09@gmail.com
    ➟ Website: www.TechGuruPl...
    ➟ Website: www.BijnorBusi...
    #NazimExcel #AdvanceExcel #MISReport #DashboardReport
    #ExcelCourse #LearnExcel #Exceltricks #Exceltips #BusinessExcel
    ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

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

  • @business-excel
    @business-excel  11 месяцев назад +2

    Download Practice File 👉 techguruplus.com/vlookup-on-large-excel-data/
    Join Excel Course 👉 TechGuruPlus.com/excel-course
    Cheque Printing Software 👉 chequeprint.in
    Telegram 👉 t.me/TechGuruPlus

  • @harshgujjar007
    @harshgujjar007 7 месяцев назад +8

    Sir mainey aapse hi sikha hai baday se baday file me ek hi formula me sara vlookup kse lagaye. Thanks sir. Aab mujhe koi bhi kitna bhi bada se bada data hi kyu na de de 30sec ke andar sara vlookup laga dunga.

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

    Thankyou so much sir first time vlookup itne ache smjh aayyaa
    Very very thankyou

    • @business-excel
      @business-excel  9 дней назад

      Wlcm , Stay connected

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

      Sir kya aapne index or match function prr video nhii bnayi hh​@@business-excel

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

    very nicely explained, got subscribed your channel for more updates, thanks for making.

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

    thank you so much for this informative video

  • @santykashyap0
    @santykashyap0 29 дней назад

    Informative video sir ♥️👍

  • @PharmalifeExportimportco
    @PharmalifeExportimportco 28 дней назад

    Thank you sir from Kuwait 🇰🇼 ❤

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

    sir define name bhi use kar sakate hai na bade data ke lie...

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

    Thank you so much for sharing.. 💫

  • @MuhammadKamran-ji4mx
    @MuhammadKamran-ji4mx 11 месяцев назад

    Hi sir,
    Sir agar isi data me daily bases pe muje different dates ka data lena ho kese aye ga mean k ap k pas ye 1 jan se 30 june tk 6 month ka data he to muje is me sir 15 feb se 15 march ya 20 april se 10 may tk chahye ho kese aye ga. Isi data me solution update kar de sir,

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

    Jab mene ise try kiya to value me 0 a gya koi help kr do

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

    Hello sir bulk email gamil kaise create kare with password

    • @business-excel
      @business-excel  10 месяцев назад

      brother bulk gmail nahi create hota, gmail don’t allow

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

    ❤❤❤❤

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

    कर्सर को जहां तथा लेजाते रहते हो गलत गलत सेल में क्लिक करते रहते हो गलत गलत सेल्स को सिलेक्ट करते रहते हो.. ये सब से समझने में कठिनाई होता है कि आप किस सेल के बारे में बोल रहे क्योंकि क्लिक कहीं और करते रहते हो।

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

    Hello sir aap kisi bich me vlookup lgake video bnaiye bahut confusion hota hai

  • @amolkhairnar7094
    @amolkhairnar7094 11 месяцев назад +1

    Sir GSTR2B KA DATA AGAR rate ke according COLUMNER purchase register mein banana ho to KAISE banaye

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

    Assalam alaikum Sir mujhy excel course krna hau me Pakistan sy hu ap teach kr skta

  • @mayurmanwatkar8482
    @mayurmanwatkar8482 4 часа назад

    Thank you so much sir😊

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

    Sir,if column index number in not in serialwize increasing Ex. we need data from column (4,3,7,8,5)

  • @exploreallmountain4925
    @exploreallmountain4925 12 дней назад

    Mujhe lag nehi

  • @nishatquamar7773
    @nishatquamar7773 11 месяцев назад +1

    Very nice explanation, the way you make us understand is really commendable.
    One suggestion here is that you can use the match function instead of row and column to make it more interesting for end user.

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

    Sir esa koi bot ya software bataye jaha apke bataye hue tarike se jab hum email nikalte hai uske badd email marketing as automation work kare or hum affiliate ke jariye income kar paye... Thanks in advance 🙂...

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

    Sir column ki jagah Match ka use bhi kar sakte the na😊

    • @business-excel
      @business-excel  2 месяца назад

      Ha vo bhi good idea hai 👍 i will try

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

    Sir , slicer ka bhi sikha dijiye excel Mai

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

    row mei n/a aa raha hai

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

    Sir protected Excell sheet me बिना unprotect किए row और कॉलम को delete केसे करे कोई फॉर्मूला है या vba के मध्यम से

  • @SumanChauhan-em5fq
    @SumanChauhan-em5fq 4 месяца назад

    Sir mera dada sirf horizontal me hi fill ho rhaa h jab me vertical dreg kr rha hu tho N/A aara h tho sir muje formula me glti hori h muje btaoo plzz jesa ap kre ho wese hi kraa hu but formula shirf horizontal hi dond pa rhaa h vertical nhi

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

    Sir i want to learn advance excel if you can

    • @business-excel
      @business-excel  Месяц назад

      Sure Sir, you can ask me on call 9536250020 about the course

  • @KirpalBisht-b8i
    @KirpalBisht-b8i 2 месяца назад

    In your website; where i used "Special character Emoji Remove" option, I need to put excel but there is no option over there

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

    not able to select source file while applying create dropdown list in company name in sheet4 in practice file any specific reason where i am wrong please help me on this.

  • @pankajkumar-ow1ex
    @pankajkumar-ow1ex 3 месяца назад

    Sir bhut accha class but mere se ctrl+D krne pr same data copy ho rha please tell😢😢😢

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

    VIDEO 20 MINUTES K HA AUR SEKHO 1 MINT MAI..
    WAAH PANDY G WAAH

    • @business-excel
      @business-excel  3 месяца назад

      Dear explain krne me to time lagta hi hai, but Vlooup apply krne me 1 minute hi lagta hai

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

      @@business-excel HAHAHA JUST KIDING SIR, AGAR 20 MINUTES MAI BHI SEEK LIA TU BHT ACHA HOGA..

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

    Sir please make a video on 26AS reconciliation under excel with tds receivable in books of A/cs

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

    How to sort multiple rows with the same company name with different revenue. ?

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

    Mene formula lagaya fir niche drag Kiya to same nahi aaya balki wohi amount aayi what to do

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

    Sir क्या आप ispe एक वीडियो बना सकते हो ❓❓👇👇
    मै excel मे gst return file बनाता हूं जिसमें पार्टी का नाम, gst nmbr, bill nmbr, total amt और cgst, sgst igst के अलग अलग colum बनाता हूं
    तो मैं चाहता हूं कि मैं जब भी amount डालूँ तो GST नंबर (state wise) के hisaab से अपने आप CGST, SGST, या IGST calculate हो जाए

  • @anuranjanhari2410
    @anuranjanhari2410 11 месяцев назад +1

    ❤Sir very useful information ❤❤

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

    How to match positive and negetive number in Excel.?

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

    Vlookup ka masla sir multiple sheet mein hein buhat se logon ko nhi pata sir is pr zara ghor karein sir

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

    Sir i get green flag

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

    Sir iske saath indirect formula kaise apply kare

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

    practise file is not downloading

  • @redleaf3807
    @redleaf3807 19 дней назад

    Dikhaiye nhi deta

    • @business-excel
      @business-excel  18 дней назад

      Change setting to 1080p in your youtube

  • @DeepakJAIN-er9uf
    @DeepakJAIN-er9uf 10 дней назад

    Your mail id sir

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

    sir plz ans zrur dia ga ap k teach krna ka andaz bht acha smj arh

  • @thetechtipps
    @thetechtipps 11 месяцев назад +1

    Very nice ❤

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

    Sir multiple sheet mein kaisy lagogy sum k sath summary banana k lye

  • @Sonusonu-gy6hi
    @Sonusonu-gy6hi 7 месяцев назад

    RESPECTED SIR JAB HUM 8:15 PAR CTRL R AND D PRESS KARTE HAI TB TABLE TO FIL HO JATI HAI BUT SAME DATA COPY HO JATA HAI SARI CELLS ME PLZ BTAIYE

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

    hi sir jab main vlookup use krte hain to F4 se $ nhi ata hai plz suggest

  • @FasihUllah-x1j
    @FasihUllah-x1j Месяц назад

    Mujh phli bar samj ai vlookup ki thank you Soo much

  • @thetechtipps
    @thetechtipps 11 месяцев назад +1

    Bahut bhadiya sir ji

  • @MayurThorat-f4m
    @MayurThorat-f4m 3 месяца назад

    So much informative content bhai🤞

  • @SawanKumar-ev5rt
    @SawanKumar-ev5rt 6 месяцев назад

    sir hlookup pe v aise hi ek video bnao.

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

    Lovely information 👌👌

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

    very interesting video

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

    Try FN+F4

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

    Thanks u sir

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

    ❤❤❤❤❤❤❤❤❤Thank You So Much Sir

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

    Very useful video

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

    Very nice and useful, isee tarah ke videos ki jaroorat hai. Thanks !!

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

    Beautiful......

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

    Superb

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

    Nice Sir ji

  • @Sonusonu-gy6hi
    @Sonusonu-gy6hi 7 месяцев назад

    11:13 par data validation karneke liye dusre sheet par click nhi ho pa rha hai plz reply kare sir ji

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

      Ok i have explained in this vdo
      ruclips.net/video/UMIp1GkcTcQ/видео.html

    • @Sonusonu-gy6hi
      @Sonusonu-gy6hi 7 месяцев назад

      @@business-excel very very thanks sir god bless you

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

    Awesome brother, best video Mila ab tak ka

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

    👌😍🔥

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

    Nice bhai❤

  • @CHATGPT-z4j
    @CHATGPT-z4j Месяц назад

    Super very good dear

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

    Bhai superb👌

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

    Is this video part of your course

    • @business-excel
      @business-excel  10 месяцев назад

      Course videos are different than RUclips videos

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

      @@business-excelsir, Are you provide certificate, if we doing the course?