Рет қаралды 46,952
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
drive.google.com/file/d/1yW30...
Download the Assignment Master Practice Folder here (All Playlist Examples at one place)
drive.google.com/drive/folder...
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#databasefunction#dgetformula#Innozant #exceldatabasefunction