Index (Match) and DGET Formula in Excel
Link to full course: https://commercecurve.com/ultimate-ex...
Take this course if you're looking for a complete course with end-to-end Excel training to accelerate your career.
The index match is a good alternative to a nested if formula or using the Ifs formula.
=index(dataset, MATCH(lookup_value, lookup_array, [match_type]))
This formula combines both the Index and Match formulas together in one equation.
When using the Index and Match formula together, the Match formula is inserted where the row syntax is located within the Index formula. The first part of the formula references the "array" which is the table upon which you are referencing.
The DGET formula is a database lookup function which references an array, and returns a result (i.e. the field referenced), with the option of setting
=DGET(database, field, criteria)
DGET is useful for quick lookups but not as flexible as INDEX(MATCH). The benefit of this formula is mainly in cases where you need to perform a lookup using multiple criteria and a VLookup is not appropriate since a VLookup only works with one criterion.
Therefore, either you use a SUMPRODUCT formula, INDEX(MATCH) or DGET.
-- DGET is short and can be simple to use in many cases.