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

[@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

[@ManojKumarBaghel1432]

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

[@Innozant]

Ok dear..👍

[@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❤️

[@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.

[@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 ❤️

[@AnuragSingh-w7g]

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

[@Krishna1119-y8n]

Your teaching method is superb sir💐

[@Innozant]

Thanks

[@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

[@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

[@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🙏❤️😊

[@cartoonloversop6019]

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

[@Innozant]

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

[@neuaryanvlogs5172]

I like your teaching approach, thank you so much.

[@Innozant]

Thanks dear..Happy Learning ❤️

[@muhammadihatsham1972]

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

[@Innozant]

Thanks dear

[@aoasoyal4272]

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

[@satishojha6240]

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

[@Innozant]

Thanks dear❤️😊🙏Good Night

[@marutipatil6399]

Ek number 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

[@karankapoor200]

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

[@Innozant]

Thanks Karan🙏😊❤️

[@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

[@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

[@mrfunny5780]

Thank you sir

[@kpandu1980]

Very good function thanks for sharing this

[@Innozant]

Thanks dear😊🙏❤️

[@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

[@kulvinder8211]

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

[@user-hq5gr9hk1j]

V well explained

[@rajpatel4596]

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

[@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 🙏❤️

[@Shivk6633]

Please confirm this formula available in 2013 or not

[@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

[@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

[@munishgandhi3564]

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

[@mohitgusain362]

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

[@anooparora2515]

Thanks Sir!

[@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 !!

[@sureshv7724]

Super ji.

[@Innozant]

❤️🙏

[@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.

[@ChandanKumar-gp8zw]

Thanks

[@MithunSapui]

Awesome Sir

[@ramcharanvishvakarma1482]

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

[@rajpatel4596]

Good👌👌

[@palashsarkar3192]

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

[@Shivk6633]

Good sir

[@Innozant]

thanks Shiv

[@shonakmdheeraj7590]

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

[@Innozant]

Ok .free time nikalke krta hu koshish

[@nehaniboriya]

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

[@Innozant]

Yes Neha 👍

[@ravishukla02]

Cold i use Match function inside DGET

[@devokedevtech2750]

Sir good function for extract value

[@Innozant]

🙏😊❤️

[@arunsandhu3087]

Nice video

[@Innozant]

Thanks dear ❤️

[@bajajelectricals681]

Sir agar sumifs me do sum range kaise de

[@V2000-c6h]

Sir is function se pehle vlookup ki knowledge jarori hai kya

[@Innozant]

Nhi to .. vlookup isse advanced version h dear

[@RamSingh-ol5xz]

Nice 👌

[@umeshvijay1814]

Good

[@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

[@pawanverma7220]

Wow! 😮 😮 😮

[@Innozant]

Thanks Pawan Ji..👍❤️🙏

[@hsgusain2054]

Amazing 🙏🙏🙏

[@Innozant]

Thanks dear

[@bhoopendraraghav9781]

Salute u sir g

[@Innozant]

Thanks Bhoopi. 🙏❤️😄

[@naeemulhassan1426]

Sir. Plz share explain Dget function in detail.

[@Innozant]

👍

[@Shivk6633]

Osm

[@Innozant]

offcourse its availablw in office 2013

[@vinayrsoni4334]

What a video sirji

[@Innozant]

Thanks Vinay❤️🙏😊

[@yaminichouhancs]

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

[@Innozant]

Bulk ke loye vloolup use kariye

[@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]

Which office using brother u

[@Innozant]

M using Office 365 subscription based

[@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

[@yolnsghf]

Dget is showing value error

[@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

[@devokedevtech2750]

Sir teligram par bhi channel bnao

[@Innozant]

Ok..soon

[@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.🙏🙏❤️❤️

[@karankapoor200]

🙏😍👍🏻

[@Innozant]

🙏❤️

[@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. RUclips channel.Downloas and start your practice now

[@gangarajuediga]

@@Innozant thanks sir

[@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]

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

[@umeshchandarana8415]

No volume

[@Innozant]

didn't get you

[@RamSingh-ol5xz]

Questions mai

[@gauravbhatia7987]

Good

[@Innozant]

♥️🙏

[@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