Topic: Use DGET for Reverse Lookup - One of the Powerful Function in Excel
Excel DGET Function is one of the powerful functions that can do a Left lookup as well as Right Lookup (unlike VLOOKUP) and ALSO easily look for multiple criteria. After using DGET function you will solve your multiple lookup excel related problems.

Disadvantages of DGET Function:
1. DGET formula can't be pulled down - you'll need to include the header for each lookup value
2. DGET returns an error (#Num error - 7:25) if there are duplicate lookup values in the range (as opposed to VLOOKUP or Index & Match which return the first match).

For additional learning material visit the: [ Ссылка ]

Topic Included: Excel DGET function, Excel database functions, Excel Dget as vlookup, Excel dget lookup, excel approximate match lookup, excel Dget Or condition, Excel Dget multiple criteria, Excel Lookup multiple criteria, Excel left lookup, Dget returns error, Dget

#shorts #dget #excel

свернуть