DGET Function in Excel: Why Nobody is Using This Beautiful LOOKUP Function | Left VLOOKUP #Excel

DGET Function in Excel: Why Nobody is Using This Beautiful LOOKUP Function | Left VLOOKUP #Excel #Trending #easyexplain
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.

Видео DGET Function in Excel: Why Nobody is Using This Beautiful LOOKUP Function | Left VLOOKUP #Excel канала Easy Explain