Excel DGET Function-VLOOKUP Problems Solved

[@RA-rh5lb]

Sir ji aap apna motivation hamesh rakhana kyoo ki mere jasie layman bahut hai idar jisko aap jaise guru zaroorath hai .. As usual informative video. thanks

[@Piyush.arya1998]

Sir the way you explain in a calm and confident way. i am a big fan of your teaching technique. keep it up sir, you are doing great ♥️

[@Innozant]

Thanks Piyush..God bless you..Keep learning and keep exploring

[@markettalkwithshad]

Thank you for posting an amazing video with such a noble intention of spreading knowledge, esp. for those who are beginners and cant afford. Your simple language and passion is reason to many people's success...Pls keep posting

[@Innozant]

Thanks..keep growing 💗

[@ManojKumarBaghel1432]

Guru ji, Ye to mere Liye Naya function hain Thank you guru ji

[@Innozant]

Ok dear..👍

[@parsuramkharbind9373]

Sir im banker And get every solution from your video Please make video advanced bank reconciliation with multiple bank ledger I,m very keen to see your video and teaching style with good concept clear

[@shahzadsiddiqui5117]

this is such a great Fn , kabhi use nhi kia tha maine , now its so handy to use...! Respect

[@Innozant]

👍😊

[@m.hussainbarahvi5998]

Bahot baria andaz hay bhai...... Allah khush rakhay apko

[@Innozant]

Thanks dear.Happy learning ❤️

[@ShivKumar-qz8ct]

D Functions is Able to help in very hard problems. Most usefull concepts I happy new Learning . Thank you Sir!!

[@Innozant]

Thanks Shiv for learning on regular basis.Keep Learning and enhance your skills.

[@excelclass347]

First time sir mene aapke channel pr visit kiya or mujhe kafi advance learn krne ko mila.... thankyou very much ✌️🙏❤️

[@Innozant]

Thanks dear..happy learning..God bless you❤️

[@mohitsharma-ym3km]

Thanks sir, wonderful video. Aap bhut Achha samjhate ho. Again thanks

[@Innozant]

Thanks Mohit Ji👍🙏Have a great day ahead.Practice jaroor kiya kijiye regular

[@vishalbhati912]

Me likhne wala tha ki ye vlookup ki tarah large data ka result nhi la sakta or aapne bata hi diya last me ki nhi la sakta. Vlookup toh vlookup hi he😜 धन्यवाद ye formula sikhane k liye

[@Innozant]

Thanks Bhati Ji.. Happy learning

[@marutipatil6399]

Ek number sir 👌👌👌👌

[@AnuragSingh-w7g]

Simplified एंड ट्रांसपरेंट टीचिंग सर❤

[@neuaryanvlogs5172]

I like your teaching approach, thank you so much.

[@Innozant]

Thanks dear..Happy Learning ❤️

[@karankapoor200]

super say bhi upar vlookup say best h formula h 👌🏻👌🏻

[@Innozant]

Thanks Karan🙏😊❤️

[@satishojha6240]

Thanku sir for new concept this really helpful function and new replacement of vlookup good night sir.

[@Innozant]

Thanks dear❤️😊🙏Good Night

[@sandeepaswal8944]

Sir All your videos worth watching and thumbs up. Sir you have very mesmerizing voice. Thank you for sharing you excel skills.

[@Innozant]

Thanks Sandeep for appreciation ,Hope you like the concept I am trying bro deliver in different way🙏❤️😊

[@muhammadihatsham1972]

A great approach to describing a function helps to grasp it. thanks

[@Innozant]

Thanks dear

[@kpandu1980]

Very good function thanks for sharing this

[@Innozant]

Thanks dear😊🙏❤️

[@bishtlokesh1297]

🙏🙏🙏🙏You are doing hard work for us thank u so much

[@Innozant]

Thanks Lokesh 🙏❤️

[@bishtlokesh1297]

Apke sare video dekhoga or lst tk kyu ke sare knowlege muje yha se available ho jayge

[@rjraviraftarup7553]

बहुत बढ़िया है 👍

[@Innozant]

❤️😊🙏

[@hemantgusain1260]

Thanks you sir for explaining dget function and their drawback.

[@Innozant]

Thanks Hemant,Hope you like the concept of DGET their Advatage and a small drawback.

[@hemantgusain1260]

@@Innozant yes sir

[@aoasoyal4272]

great ...thank u sir,,, one quesion kya vlookup chod de use karna ya uska koi alag mahtv hai

[@javedamu]

Sir. All your video are worth watching. I am still learning excel. But passion with which you explains is awesome..

[@Innozant]

Thanks Javed ji for your valuable appreciation 🙏❤️

[@cartoonloversop6019]

सर , यु टयूब पर Excel के काफी विडियो देखे हे पर उसमे वह चीज नही मिलती जो आप के विडियो मे मिलती हे और वह हे आपकी Smile सर आप यु ही विडियो बनाते रहे

[@Innozant]

Thanks dear itne pyare aur valuable appreciation ke liye..God bless you dear

[@user-hq5gr9hk1j]

V well explained

[@mrfunny5780]

Thank you sir

[@HajishabirMemon]

Really appreciate your effort , But Vlookup and Dget has little difference Dget only works as search such as use only one row , but vlookup works on multiple row i-e if you want to fetch data from multiple row to another multiple row than vlookup is best

[@kulvinder8211]

Sir if we want to get the result like this then we can use the filter formula which is even better dget formula.

[@rajpatel4596]

Good👌👌

[@munishgandhi3564]

Is there any video about making of digital visiting card in excel ?

[@devokedevtech2750]

Sir good function for extract value

[@Innozant]

🙏😊❤️

[@GamingWorld-jy9kk]

Thank you Sir Itna achxa teach Karne k bawajud apka subscribe Kam hai Views vi Kam Akhir kyu ??

[@Innozant]

Koi nhi der s aayega viewed ko samajh .mujhme bht patience hai😊

[@GamingWorld-jy9kk]

@@Innozant ap k teach se Mai bahut impressive huwa Sir

[@sureshv7724]

Super ji.

[@Innozant]

❤️🙏

[@hsgusain2054]

Amazing 🙏🙏🙏

[@Innozant]

Thanks dear

[@anooparora2515]

Thanks Sir!

[@MithunSapui]

Awesome Sir

[@bajajelectricals681]

Sir agar sumifs me do sum range kaise de

[@RamSingh-ol5xz]

Nice 👌

[@Shivk6633]

Please confirm this formula available in 2013 or not

[@nehaniboriya]

sir we can add (match function) in field side.

[@Innozant]

Yes Neha 👍

[@dineshpanihar5863]

Sir can we use DGET on different sheet mean to say that can we give database argument to another sheet and bring the output to main sheet.

[@rajpatel4596]

Sir, database or header ke bich me blank row ho to kya DGET function ko kaise kam karva sakte he ? Please reply sir

[@ravishukla02]

Cold i use Match function inside DGET

[@RA-rh5lb]

Sir ji I know how to process vlookup /Xlooup and index match and now learned Dget. So how these functions are different from the the advanced filter. Ap ke paas aise koi video hai jise compare kar sake

[@maxrl3267]

Hello Sir Main Aap ke Video se Aap se Bahut Kuch sikha hu me Aap ke Chanel pr ghanto bitata hu mujhe bhahut kuch milta hai sikhne ko.......Us k Liye Bhahut Bhahut Dil se thank's Dhanywad Aap ka. Lekin Sir Ek Problem Aa Rahi hai jo aap ne (DGET) Function bataya ha bahut achcha hai lekin me is ko practical kar rha hu to kuch data to sahi aa rha hai lekin Kuch first ki 5 Entry me value #N/A Aa Rha Hai... Sir Esa Kyu...? baki row num. ka data sahi aa rha hai....🤔😊

[@Innozant]

Thanks

[@Innozant]

Sahi se apply kariye formula koi error nhi aayega

[@ramcharanvishvakarma1482]

Pls share advance DGET for mula to drag. Or to overcum its deficency

[@arunsandhu3087]

Nice video

[@Innozant]

Thanks dear ❤️

[@gaureeshankarsharma2930]

Sir ye dusre sheet se data extract karke le ayega sir ?

[@kulvinder8211]

Then why should we use dget. If there are any other advantages then please tell !!

[@Shivk6633]

Good sir

[@Innozant]

thanks Shiv

[@ChandanKumar-gp8zw]

Thanks

[@rupak6618]

hello sir kya hum Dget se vlookup jaise complete record laasakte hain kya

[@Innozant]

Haan bilkul la skte h even reverse lookup bhi

[@rupakjana2]

@@Innozant sir please thora sa process bataye na complete record kaise lana hain

[@shonakmdheeraj7590]

Make video on vendor reconsile ledger in excel or any excel utilitt

[@Innozant]

Ok .free time nikalke krta hu koshish

[@palashsarkar3192]

Dear Sir, could you please help me, how can I set every print page total sum automatically?

[@yaminichouhancs]

Sir ye bulk data ke ly kaise kam karta hai;?

[@Innozant]

Bulk ke loye vloolup use kariye

[@pawanverma7220]

Wow! 😮 😮 😮

[@Innozant]

Thanks Pawan Ji..👍❤️🙏

[@vinayrsoni4334]

What a video sirji

[@Innozant]

Thanks Vinay❤️🙏😊

[@bhoopendraraghav9781]

Salute u sir g

[@Innozant]

Thanks Bhoopi. 🙏❤️😄

[@Zcbmkh]

Dget is showing value error

[@gangarajuediga]

Which office using brother u

[@Innozant]

M using Office 365 subscription based

[@naeemulhassan1426]

Sir. Plz share explain Dget function in detail.

[@Innozant]

👍

[@bhavishyasaini1992]

Date pr work kaise krega pls batao

[@shonakmdheeraj7590]

Dear sir please clear in which condition we use dget function

[@Innozant]

Kindly watch dget video.i already explained dear..ye vlookup ke substitute ke jagah use kr skte h

[@Shivk6633]

Osm

[@Innozant]

offcourse its availablw in office 2013

[@V2000-c6h]

Sir is function se pehle vlookup ki knowledge jarori hai kya

[@Innozant]

Nhi to .. vlookup isse advanced version h dear

[@gauravbhatia7987]

Good

[@Innozant]

♥️🙏

[@mohitgusain362]

Sir can I do a job by seeing only your video without any certificate

[@RakeshSingh-qo5nd]

Sir ye video only playlist me visible ho rha hai aur apke upload section me bhi nhi show ho rha aisa kyu.... Kuch time tak to private tha abhi ko basic Playlist me visible hua hai.... Aur iska notification bhi nhi aaya hai....

[@Innozant]

Uploaded ..Watch It Now

[@RakeshSingh-qo5nd]

@@Innozant already watched 😀😎

[@Innozant]

Good

[@AP-gr4ij]

Sir Array ki video bna do plz

[@Innozant]

Seprate playlist available hai array & sumproduct ka

[@dynasticdraculagaming8668]

Sir koi aisa formula batao ki ( 1 cell me sirf 25 likhne se uska month and nad year aajaye) jaise 25 likhu to 25 March 2023 aajaye

[@gangarajuediga]

I want latest Ms office plz send the link

[@Innozant]

If you want to use iffuce 365 you may use Web version..You may able thanks practice all latest formula of oddice 365 You may find office 2016 or 2019 download link are the in no. KZbin channel.Downloas and start your practice now

[@gangarajuediga]

@@Innozant thanks sir

[@devokedevtech2750]

Sir teligram par bhi channel bnao

[@Innozant]

Ok..soon

[@umeshchandarana8415]

No volume

[@Innozant]

didn't get you

[@karankapoor200]

🙏😍👍🏻

[@Innozant]

🙏❤️

[@msexcelgooglesheet374]

I thought who knows VLOOKUP, that person is awesome in excel. par aaj pata chala ki vlookup to INDEX MATCH, NAMING RANGE, DGET, SUMPRODUCT ka bachcha hai..............😜🤣

[@Innozant]

Gm,abhi to Vlookup ke kitne saare Booster aane banki hain mere dost..Happy Learning.🙏🙏❤️❤️

[@RamSingh-ol5xz]

Ek dout hai mujhe

[@Innozant]

Ask your doubt?

[@RamSingh-ol5xz]

Mai apko WhatsApp send Kar duga record send Kar duga mujhe kahaa problem ho rahaa hai

[@Innozant]

Ok.sure

[@paramjeet975singh3]

Sir ab to mera question solve kara diziye pls

[@Innozant]

Kaunsa Question reh gya ab aapka dear.

[@paramjeet975singh3]

@@Innozant lucky @ abc. Com350 [e-mail] 650 [e-mail] Output Luck@abc. Com [e-mail] Singh @abc.com

[@Innozant]

Iska solution to bheja tha aapko..ok explanation ka video bna denge

[@paramjeet975singh3]

@@Innozant sir video bana do na ,,,,,, ayse samj ni aa raha hai ki kaise hoga ...plss

[@RamSingh-ol5xz]

Questions mai

[@umeshvijay1814]

Good

[@mohitgusain362]

Sir can I do a job by seeing only your video without any certificate

[@Innozant]

Offcourse Yes...Skills is required

[@mohitgusain362]

Ook sir and thx for that wonderful. And proper full course of Excel it is very helpful for me