DGET Function - The Secret VLOOKUP Alternative for Multiple Conditions
ฝัง
- เผยแพร่เมื่อ 6 ต.ค. 2024
- 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;
www.computerga...
** Online Excel Courses **
The Ultimate Excel Course - Learn Everything ► bit.ly/Ultimat...
Excel VBA for Beginners ► bit.ly/37XSKfZ
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2Siivkm
Connect with us!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1