Use DGET for Reverse Lookup - One of the Powerful Function in Excel | Softech
HTML-код
- Опубликовано: 19 авг 2024
- 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: / @softechstudy
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
Good job sir
Bhai Mene advance excel kaa pura course kar chuka hu mujhe almost 75℅ excel kaa knowledge h. Job ke liye kaise aply kar sakta hy hu
Same here bro
Freelancer me krlo apply
F4 daba ke freeze kyu kiya jata he
Excel ko chalaane key liye kitna ram maximum hona chahiye taki super💻 computer💻 jaisa performance😝 mil jayega to🤣 next🚕 government🚕 hee🚕 ban jayegi apki