Excel DGET Function-VLOOKUP Problems Solved

Excel DGET Function is database function, can look for multiple criteria and also can do a Left lookup (unlike VLOOKUP).

Excel DGET function advantages:
1. DGET is easy to apply and can look for approximate matches
2. DGET can lookup values to the left
3. DGET can match multiple criteria
4. DGET can look for OR, AND conditions
5. DGET acts like an automatic super filter

Excel DGET disadvantages:
1. You can't apply it to multiple cells
2. DGET formula can't be pulled down
3. If there are duplicate lookup values in the range DGET returns an error (#Num error)

Download the Practice Workbook Direct Link
Download the Assignment Master Practice Folder here (All Playlist Examples at one place)

Let's Connect:

#databasefunction#dgetformula#Innozant #exceldatabasefunction

[RA-rhlb]

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

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 ♥️

[muhammadihatsham]

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

[neuaryanvlogs]

I like your teaching approach, thank you so much.

[sandeepaswal]

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

[shahzadsiddiqui]

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

[parsuramkharbind]

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

[mohitsharma-ymkm]

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

[ShivKumar-qzct]

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

[excelclass]

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

[m.hussainbarahvi]

Bahot baria andaz hay Allah khush rakhay apko

[ManojKumarBaghel]

Guru ji,

Ye to mere Liye Naya function hain

Thank you guru ji

[satishojha]

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

[aoasoyal]

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

[kpandu]

Very good function thanks for sharing this

[karankapoor]

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

[hemantgusain]

Thanks you sir for explaining dget function and their drawback.

[bishtlokesh]

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

[kulvinder]

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

[munishgandhi]

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