Using the DGET Formula in Excel in hindi | Excel DGET Function Solves of Your VLOOKUP Problems

Your learn in this video How to Use the DGET Formula in Excel in hindi | Excel DGET Function Solves of Your VLOOKUP Problems. Excel DGET Function is one of Excel's "forgotten" database functions that can do a Left lookup (unlike VLOOKUP) and ALSO easily look for multiple criteria. Little known Function in Excel that is better than VLOOKUP or INDEX + MATCH
#dgetfunction #dgetinexcel #advancedexcel
www.amazon.in/shop/computergyanguruji
Canon Dslr:- amzn.to/3ad4lIx
Tripod:- amzn.to/3aitaTJ
Generic 3.5mm Lapel Mic:- amzn.to/3cbqV6e
Boya M1 Mic:- amzn.to/2wPLtku
Follow us on
instagram
/ computergyanguruji
Twitter
/ c_g_guruji
Facebook
/ computer-gyan-guruji-1...
MS Excel Videos
• Hindi English Dictiona...
MS Word
• MS Word
MS PowerPoint
• MS Power Point
MS Paint
• MS Paint
MSW Logo
• MSWLogo
Computer Education
• Education
Other
• Other video
Tally
• Tally ERP.9 Rules of D...
Internet
• internet
Computer GK
• GK
Reasoning
• Reasoning
Airthmatics
• Airthmetic
1. DGET is an easy formula - Excel DGET expalined
2. DGET can look for approximate matches
3. DGET can look for OR conditions - If either condition is met
4. DGET can match multiple criteria
5. DGET can lookup values to the left
6. DGET acts like an automatic filter

[@krishnatamrakar2524]

What About Duplicate Same Father Name in Same Address ?

[@sagarrajpoot3740]

sir dget aur index formula office 2010 me nahi work kr raha hai
pls help me sir

[@javedahmed8343]

Your explanation with questions by yourself make the concept much clear. Thank u sir.

[@ravibhushansinha7916]

Please use this data with dget horizentally

[@rahulkatiyar6950]

Sir ji apne filter kaise lagaya automatically

[@ParveenKumar-ml1tz]

Sir Mera top ke column me formula lag Jata hai mager uske baad kisi bhi column me kaam nahi ker raha kya ho raha hai

[@RA-rh5lb]

bahut badiya Sir ji. thanks

[@heeralalkumawat2132]

Super support 🙌💪

[@AkhileshYadav-lt5sb]

Good video sir

[@sunilupadhyay4365]

Fromule ko drag kese kre

[@Souvik495]

Nice

[@ruchikasharma8302]

थैंक्स सर।

[@ravibhushansinha7916]

How to use dget formula horizontally in Excel/ Google sheets.

[@ashishrawat8276]

Sir kya yeh formula sirf ek hi row mein kaam krta hai, m isko drag kr rha hun toh neeche #Num error aa rha hai

[@satishsvernekar]

Its works if we are searching single id,
But its not working in full student pay fees list.
"Automated Fees Status and fees receipt Software in Excel in hindi".

[@computergayanbyprabodhkuma7426]

Sir, mai ek invoice banaya hu usme brand name or product name ka use kar k ek dependent drop down banaya hu mai ye chahta hu ki dget function use kar k rate ko fatch karu lakin ye sirf ek hi cell me ho raha hai aage dusre cell me formula copy karne par error ho raha hai kya kare..

[@Vairagi73]

Thank you गुरूजी... आप ने नया function सिखाया

[@businessfinancialsbftc3876]

Do something for office people, not only school

[@manjit.sarania]

Thank you sir. 🙏🙏

[@merajhussain3674]

criteria ko lock kaise kare

[@yakubkhan5649]

Are bhai yeh pure sheet may nahi Lagra ak he line may

[@mdkakhan]

Nicely explained Sir

[@pronabdey5864]

Nice explained Sir ,🙏

[@mdroman3017]

Super video boss

[@ssrkrishna9539]

Good Sir

[@kmanoj392]

NICE CLASS SIR

[@apeduworld7004]

Jhakash video sir