Why VLOOKUP Not Working

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

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

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

    Vlookup Full Tutorial Basic to Advanced
    ruclips.net/video/V4YgQTFLmyc/видео.html

    • @AmitKumar-jj7pz
      @AmitKumar-jj7pz 3 года назад +1

      Bhai... Kabhi kabhi formula lagatey hai to ..pura formula hi likha aa jata hai...kya kre...v look up me

    • @AKGAMING-bu7gy
      @AKGAMING-bu7gy 2 года назад

      Deepak bhai ek problem h , mere pas bahut sara data h jisme date h, toh problem yeh h ki , kuch jagah dated sahi aa rahi h , but kuch jagah 11-03-2022 ki jagah 03-11-2022 show ho raha h , iska koi solution h?

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

      Sir mene values turn as #N/A, but when i check one by one data is present in other sheet

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

    थैंक्स सर।कई दिनों से परेशान था इस प्रॉब्लम से।आज सुबह आपका वीडियो देखा, समाधान हो गया।थेँक्स गॉड ब्लेस यू

  • @joker-ze6hq
    @joker-ze6hq Год назад +2

    thanks for this video bhai 30 minutes se try kar raha tha main NA NA NA sirf after this video sab clear hogaya

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

    Thank you Thank you Thank you Thank you Thank you... I was facing this problem since long time and I have to make such data 3 to 4 times a day. You are a real saviour 🙏

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

    Thank you so much brother , i was facing this problem for 2 year but never got solution until now . Well done brother and thank you so much once again

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

    Boss thanks after searching error I watched your video that has resolved my issue. Once again thank-you.

  • @VivekSingh-mz9gx
    @VivekSingh-mz9gx Год назад +2

    You are superb bro.
    You have solved my long time issue.
    Keep it up

  • @puneetvij8433
    @puneetvij8433 5 лет назад

    Deepak Sir,
    बहुत बारीक difference बताया आपने space का text और number में, thanks alot. ; )

  • @mdsakirhussain3383
    @mdsakirhussain3383 5 лет назад +3

    I have already experienced this .....Thanks for being aware to your audience ..

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

    Thank you, koi to mila jse sachmuch excel aata hai. Excellent 👍🏻

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

    This is very needful Thanks

  • @DeepakEduWorld
    @DeepakEduWorld  5 лет назад +1

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

  • @ekla_chalo
    @ekla_chalo 5 лет назад +1

    Very Nice bahat achcha chez sikh ne ko mila...thanks..

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

    All your videos I have studied very excellent job
    I want to learn how to make a salary slip which show annual amounts changing only year plz explain..👏

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

    Oh my god i have been sitting for hours with this query 😭...now its solved...thanks a lot🙏🙏🙏🙏

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

    Thanks it worked and you made my weekend

  • @Anaskhan-mc5er
    @Anaskhan-mc5er 5 лет назад

    KIA THA BOHT PARESHAN AB SAMJH MN AYA THANX YEHI TW CHAHIYE THA

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

    Thanks a lot brother , you taught me a great solution

  • @EtawahTypist
    @EtawahTypist 5 лет назад

    Pahli baar trim formula dekha thank u sir

  • @SANDEEPYADAV-uf7rs
    @SANDEEPYADAV-uf7rs 5 лет назад +1

    Sir good video sir aapka batane ka tarika very smart h sir ms Excel me school ka fees monthly travel fees advanced fees back fees exam fees book fees teacher ka salary etc sir please bataye

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

    Thankyou very much...literally irritates in my office today due to this prblm

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

    Thankyou very much sir 2 ghante se pareshan tha 😨

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

    Thanks Boss You saved my work👌🏻👌🏻👌🏻👌🏻👌🏻👌🏻👌🏻👌🏻👌🏻👌🏻👌🏻👌🏻👌🏻👌🏻👌🏻👌🏻👌🏻👌🏻

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

    thank u bro I was facing this problem since long time

  • @Anonymous-mz4fn
    @Anonymous-mz4fn 4 года назад

    thanks buddy i was struggling to know what was going wrong in my formula...

  • @sudhanvapatki2142
    @sudhanvapatki2142 2 года назад +2

    Excellent ....We need more such trouble shooting videos ... Thanks 👍

  • @Upendra.Pulapati
    @Upendra.Pulapati 2 года назад

    Thanks, it solved my problem

  • @vijaykumar-qg2jz
    @vijaykumar-qg2jz 5 лет назад +1

    Thanks brother i am from Punjab

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

    Thanks for information

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

    Nicely explained

  • @bohemiacool8761
    @bohemiacool8761 5 лет назад +1

    NAYA SIKHA AAJ KUCH,, THANKS..... BHAI EK CONFUSION H KI MAINE APNI SHEETS ME CONDITIONAL FORMATING AUR DATA VALIDATION KIYA H, EXCEL HANG KRNE LGA H........

    • @DeepakEduWorld
      @DeepakEduWorld  5 лет назад +1

      Okayyy.. Please wait.. I ll publish video on how toh make slow excel workbook faster

    • @bohemiacool8761
      @bohemiacool8761 5 лет назад

      @@DeepakEduWorld thanks a lot

    • @bohemiacool8761
      @bohemiacool8761 5 лет назад

      @@DeepakEduWorld thnx a lot

  • @Success_Mantra82
    @Success_Mantra82 5 лет назад +1

    Very nice video Deepak ji.!
    Rajendra from Delhi

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

    thanks yehi problem tha solve ho gaya.

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

    Thanks yr bhai me kbse confuse hora tha ki essa Q hora he.

  • @sagardeokar259
    @sagardeokar259 5 лет назад +1

    Thanks sirji

  • @nirupammishra7434
    @nirupammishra7434 5 лет назад

    Superb tricks. Thanks

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

    Thanks my work is complete

  • @दुर्गा-झ6भ
    @दुर्गा-झ6भ 3 года назад +1

    Very useful video

  • @ayeshaKhan-dd4dg
    @ayeshaKhan-dd4dg 5 лет назад +1

    Nice video sir Thanku sir Ms word Mai different formate form bna sikhaiye and pdf conversion fillable bhi sikhaiye thanku

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

    THIS IS WORKS LIKE CHARM! THANKS

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

    Thank you 🙏

  • @harishphogat5689
    @harishphogat5689 5 лет назад

    Nice video sir
    You are Rhe The greatest teacher in my life
    Sir pls excel.me what if Analaysics command ki video bnao na complete
    Senrio manager, Goal seek, Data table

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

    thank you for help..!!

  • @karthikrajgopal8627
    @karthikrajgopal8627 5 лет назад +1

    Nice video ji

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

    Thanks bahut badhiya

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

    Thanks so much sir ❤️❤️

  • @rakibulhasan8592
    @rakibulhasan8592 5 лет назад +2

    thanks,

  • @amjadmkhan3383
    @amjadmkhan3383 5 лет назад

    Sir Tally ki series shuru kare.other channel pe samajh nahi aa raha.umeed hai aap step by step batayenge. Thanks

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

    Thanks really helped

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

    Thank you soo much !!

  • @BilalAhmad-sp8im
    @BilalAhmad-sp8im 2 года назад +1

    Thanks alot

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

    Thank You so much

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

    Sir maine marksheet banane k liye percentage add karne ke liye lookup function use kiya tha #N/A dikha raha hai iska kya solution hai

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

    Excellent bro

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

    Thanks sir

  • @MDIRFAN-en8tk
    @MDIRFAN-en8tk 2 года назад

    Thanks Sir. 🌹

  • @bsyoutuber3827
    @bsyoutuber3827 5 лет назад +1

    Super bro 👌👌👌👍👍

  • @moloyghosh2269
    @moloyghosh2269 5 лет назад +1

    sir please make a video on use of F4 in excel.

  • @FarahVision
    @FarahVision 5 лет назад

    Nice video sir...
    And @Deepak Eduworld meri request kab puri krengy? Waiting for my request..
    PIVOT TABLE me SLICER ka use batayein.. SLICER se report kese bna sakty hain.. ?? for example: SLICER per click krne se Student A ki detail ajaen or next click krne se Student B ki details show hon.. plzz video bnayein is topic pr in detail..

    • @DeepakEduWorld
      @DeepakEduWorld  5 лет назад

      I ll publish video as soon as possible.. Please wait.

  • @m.danish445
    @m.danish445 5 лет назад

    Very very nice

  • @sanjeebrath3943
    @sanjeebrath3943 5 лет назад

    I have added a formula in normal excell and the same formula not working in wps spreadsheet excellsheet like number to word convert formula, please suggest

  • @kirandeepchoudhry9232
    @kirandeepchoudhry9232 5 лет назад

    Nice one, sir can't we use vlookup with trim. Sir I requested you to make video on table in detail

  • @mdtausifiqbal
    @mdtausifiqbal 5 лет назад +1

    nice solution

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

    Thanks trim formula

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

    Thanks Sir....

  • @ravindragurav1670
    @ravindragurav1670 5 лет назад

    Good solution

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

    Thank u sir ❤️

  • @allhakabaapbaap1812
    @allhakabaapbaap1812 5 лет назад +1

    thanks yaar

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

    Thank atleast I got the idea

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

    Good job👍

  • @ArvindKumar-er7lr
    @ArvindKumar-er7lr 4 года назад

    How to use vlookup for numerical value comes from different sheet and containing formula also?

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

    Thank you

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

    Wonderful

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

    Sir, main vlookup formula use kia lekin proper kam nehi kar raha hai, 0.00 aa raha he figure

  • @EtawahTypist
    @EtawahTypist 5 лет назад

    Very nice sir

  • @vikas18sharma
    @vikas18sharma 5 лет назад +1

    Awsome

  • @ArunYadav-mi9eh
    @ArunYadav-mi9eh 3 года назад +1

    Multiple sheet pe vlookup ka data sahi hai phir bhi error kyo de raha hai pls tell me about this problem
    Thanks

  • @amjadmkhan3383
    @amjadmkhan3383 5 лет назад

    Good One.

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

    ThAnks

  • @kr.laxman
    @kr.laxman 5 лет назад

    Good..one..

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

    Sir ek se zyada Excel sheet me v look up kaise kare?

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

    Thanks lekin trim vi kuch cases mein kam nehin karraha hain

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

    Fantastic

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

    Life saver

  • @vanishreesharma2241
    @vanishreesharma2241 5 лет назад

    I did TRIM function for numeric values, but still there is space at the end when i double click that cell. why? please help. Thank you.

  • @nandakhemundu9462
    @nandakhemundu9462 5 лет назад +2

    I am facing problem with vlookup (Lookup value is same but #N/A error)this error is not for space or spell but other cause Please help me to fix it.

    • @DeepakEduWorld
      @DeepakEduWorld  5 лет назад +1

      If your lookup value is present in data.. then only the cause of space.. plz check lookup value and.. all lookup values in data.. that no extra space is available

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

      Same problem.... Agar mai kisi person k liye lookup formula ka use kar rata hu to ek bar to sahi kam karta hai lekin dusri bar agar usi same person ke liye use karta hu to #N/A batata lekin dusre person k sath kitni bhi bar use karlo sahi batata h.. Pls help

  • @ManojSingh-yt9tg
    @ManojSingh-yt9tg 3 года назад

    Helpful 😊

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

    U r great

  • @minkusmarteducation
    @minkusmarteducation 5 лет назад

    Good sir

  • @k.g.maheshwar
    @k.g.maheshwar 3 года назад

    Thanks Bosssssss

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

    Sir
    Mera v lookup formula kam nahi kar raha hai. Mai ek formula kar raha hoan. Main column jahan se v lookup utha raha hoan.
    Select karne ke bad.
    Alt+d+e ka formula laga raha hoan.
    Comma remove karne ke liye.
    Means text mai convert karne ke liye

  • @mdrashidhussain7168
    @mdrashidhussain7168 5 лет назад

    Thanks

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

    Vlookup iferror & multiplication ke liye kaise formula lagaye

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

    Bro I am facing some issues while using vlookup. Maine all entries check key but kisi may bhi extra space nahi thi. Or vlookup koi random number generate ker k show ker Raha hai. Jo Meri sheet may kahi bhi nahi. Kindly help me regarding this issue.

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

    sir thanks so much. but still my problem is not solved

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

    tysm sir

  • @rahulkushwaha5798
    @rahulkushwaha5798 5 лет назад +2

    Tally ki video Bataye sir

  • @syedyousufghansi7402
    @syedyousufghansi7402 5 лет назад

    3*3 table,
    i want to find some value first check row header if yes then find the value in these column, second condition the value is not available in the column (ex. value 2 is not available so its show nearest greatest value like 4) pls give me solution

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

    Bhai maan gaye

  • @md.saifulislamtuku9303
    @md.saifulislamtuku9303 5 лет назад

    thanks