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

preview_player
Показать описание
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
Follow us on
instagram
Twitter
Facebook
MS Excel Videos
MS Word
MS PowerPoint
MS Paint
MSW Logo
Computer Education
Other
Tally
Internet
Computer GK
Reasoning
Airthmatics
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
Рекомендации по теме
Комментарии
Автор

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

javedahmed
Автор

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

Vairagi
Автор

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

sagarrajpoot
Автор

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

ParveenKumar-mltz
Автор

Sir ji apne filter kaise lagaya automatically

rahulkatiyar
Автор

Please use this data with dget horizentally

ravibhushansinha
Автор

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

ashishrawat
Автор

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

computergayanbyprabodhkuma
Автор

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

ravibhushansinha
Автор

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".

satishsvernekar
Автор

What About Duplicate Same Father Name in Same Address ?

krishnatamrakar
Автор

Do something for office people, not only school

businessfinancialsbftc
Автор

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

yakubkhan