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/UltimateExcel Excel VBA for Beginners ► http://bit.ly/37XSKfZ Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2ujtOAN Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm Connect with us!