DGET Function - The Secret VLOOKUP Alternative for Multiple Conditions
In this video, we look at the DGET function - the secret alternative to VLOOKUP for multiple conditions.
This function appears to fly under the radar, yet is incredibly useful. The most well-known alternative to VLOOKUP is the INDEX and MATCH combination, but DGET should also be considered.
The greatest strength of DGET is the ability to handle multiple conditions. By using a criteria range, it is simple to enter multiple conditions.
It relies on the headers matching so can lack the flexibility of other formulas, but the simplicity is a plus.
Find more great free tutorials at;
https://www.computergaga.com
*** Online Excel Courses ***
The Ultimate Excel Course – Learn Everything ► https://bit.ly/2Ag5AKH
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/2UlTfvB
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm
Connect with us!
LinkedIn ► https://www.linkedin.com/company/18737946/
Facebook ► http://www.facebook.com/computergaga
Twitter ► http://www.twitter.com/computergaga1
Видео DGET Function - The Secret VLOOKUP Alternative for Multiple Conditions канала Computergaga
This function appears to fly under the radar, yet is incredibly useful. The most well-known alternative to VLOOKUP is the INDEX and MATCH combination, but DGET should also be considered.
The greatest strength of DGET is the ability to handle multiple conditions. By using a criteria range, it is simple to enter multiple conditions.
It relies on the headers matching so can lack the flexibility of other formulas, but the simplicity is a plus.
Find more great free tutorials at;
https://www.computergaga.com
*** Online Excel Courses ***
The Ultimate Excel Course – Learn Everything ► https://bit.ly/2Ag5AKH
Excel VBA for Beginners ► http://bit.ly/37XSKfZ
Advanced Excel Tricks ► https://bit.ly/2UlTfvB
Excel Formulas Made Easy ► http://bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm
Connect with us!
LinkedIn ► https://www.linkedin.com/company/18737946/
Facebook ► http://www.facebook.com/computergaga
Twitter ► http://www.twitter.com/computergaga1
Видео DGET Function - The Secret VLOOKUP Alternative for Multiple Conditions канала Computergaga
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![INDEX MATCH Explained (An Alternative to VLOOKUP)](https://i.ytimg.com/vi/yH_ArqoB0no/default.jpg)
![Don't Use Excel Filters! Use This Incredible Excel Formula Instead ...](https://i.ytimg.com/vi/Qi1nfN5F8F4/default.jpg)
![Create a searchable drop down list in Excel](https://i.ytimg.com/vi/vkPoViUhkxU/default.jpg)
![Highline Excel 2013 Class Video 20: VLOOKUP, DGET & MATCH For Looking Up Records 7 Examples](https://i.ytimg.com/vi/ZFQkRhlCNzI/default.jpg)
![Advanced PivotTables: Combining Data from Multiple Sheets](https://i.ytimg.com/vi/Tu6SGU-rK6c/default.jpg)
![DGET - Powerful VLOOKUP, INDEX-MATCH Replacement - Google Sheets Tutorial](https://i.ytimg.com/vi/fhWR8yXYqwY/default.jpg)
![Excel Magic Trick 1311: Return Multiple Items from One Lookup Value & Show Total for Invoice Items](https://i.ytimg.com/vi/mkQhBBE1PqQ/default.jpg)
![☑️ Top 30 Advanced Excel Tips and Tricks](https://i.ytimg.com/vi/Hj4PVFYhqhQ/default.jpg)
![How to build Interactive Excel Dashboards](https://i.ytimg.com/vi/K74_FNnlIF8/default.jpg)
![Use VLOOKUP to Find the 2nd Match (or nth Match)](https://i.ytimg.com/vi/v9k8CoJQ-p0/default.jpg)
![Excel DGET Function Solves 2 of Your VLOOKUP Problems](https://i.ytimg.com/vi/57MARBvYVs4/default.jpg)
![Excel Magic Trick 781: Three Way Lookup: INDEX and MATCH and Concatenated Ranges & Cells](https://i.ytimg.com/vi/zjfpA2kJhm8/default.jpg)
![Data cleaning in Excel - 10 tricks *PROs* use all the time](https://i.ytimg.com/vi/SNVjndgWBlw/default.jpg)
![Searchable Drop Down List in Excel (Very Easy with FILTER Function)](https://i.ytimg.com/vi/Z-h2UER3b_0/default.jpg)
![6 Incredible Excel INDEX/MATCH Lookup Examples - Workbook Included](https://i.ytimg.com/vi/Lh0vvEhw4Tk/default.jpg)
![Why you should use Excel's Cube functions instead of GETPIVOTDATA.](https://i.ytimg.com/vi/KfGlCEcosQo/default.jpg)
![Create Multiple Dependent Drop-Down Lists in Excel (on Every Row)](https://i.ytimg.com/vi/7mo4COng7Sg/default.jpg)
![Excel for Accounting - 10 Excel Functions You NEED to KNOW!](https://i.ytimg.com/vi/m_SH0TOLsIc/default.jpg)
![Create Dynamic Excel Filter - Extract data as you type](https://i.ytimg.com/vi/tCahRfEGj1g/default.jpg)
![Return Multiple Match Results in Excel (2 methods)](https://i.ytimg.com/vi/fDB1Ktyhp3Y/default.jpg)