Why Nobody is Using This Beautiful LOOKUP Function?
DGET in Excel

Why Nobody is Using This Beautiful LOOKUP Function?

Today We will explore a function which is more powerful then VLOOKUP and Simpler then INDEX MATCH Function.
This function is so powerful that it can Lookup RIGHTWARD as well as LEFTWARD. The best part about this function is its simplicity.
It’s so simple that this function has only three arguments which are:
Where- The Table Range
What- The Lookup Value
Which- Criteria
Here is the catch: By declaring only these three arguments you can lookup Multiple criteria in a single table.
Yes, You heard it right.
You can bring the value by matching multiple criteria in a table.

Download Practice File Here:

DGT

More Details   SUMIF Function in Excel: The Complete Guide for 2019

Akash Gurjar

Hi, I am Akash. I am Hobbyist Blogger and YouTube Creator. I like to explore and learn new things all the time. I own a website easyexplain.info and a YouTube Channel EasyExplain. Join Me.

Leave a Reply