Excel DGET Function-VLOOKUP Problems Solved
48.4 هزار بار بازدید -
4 سال پیش
-
Excel DGET Function is database
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
https://drive.google.com/file/d/1yW30P9V7wgda_2cabI1GV98TUdac7gIq/view?usp=sharing
Download the Assignment Master Practice Folder here (All Playlist Examples at one place)
https://drive.google.com/drive/folders/1y5h4SMwPLk12xZ2-2U1SDBIQqyH5bz4P
Website - "http://www.innozant.com/"
Let's Connect:
Instagram ►http://www.instagram.com/innozantoffi...
Facebook ► https://www.facebook.com/innozant
Twitter ► https://twitter.com/innozant
Linkedin ► https://www.linkedin.com/company/inno...
#databasefunction#dgetformula#Innozant #exceldatabasefunction
4 سال پیش
در تاریخ 1399/06/26 منتشر شده
است.
48,499
بـار بازدید شده